top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How do mapping parameter and mapping variables differ?

+1 vote
345 views

How do mapping parameter and mapping variables differ?

posted Feb 27, 2015 by Sunil

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Mapping variable is the scenario where values change when the session is executed. When it is finished, the value at the end is stored by the Informatica server only to be used when the process restarts. Mapping parameters are the values that remain the same when execution is taking place. Mapping usage and parameters are described by mapping procedures. Before the session begins values are assigned to the parameters.

answer Mar 3, 2015 by Shweta Singh
Similar Questions
+3 votes
Source Qualifier SQL Override Error with Mapping Variables

I am using a mapping variable of date/time data-type and aggregation MAX In Source Qualifier SQL Override i am giving select col1,col2 from tbl where col1>$$dt

(col1 is also date data type)

When i am validating the query it is giving Invalid Query and error was

 [Microsoft][ODBC driver for Oracle][Oracle]ORA-00933 : SQL command not properly ended

I have also done extraction of characters like select col1,col2 from tbl where to_char(col1,'DD-MM-YY')>to_char($$dt,'DD-MM-YY') but still the same same

I am not getting what the error is and the same thing if i am trying for number column the it is validating fine and performing incremental extract also.

Any suggestions regarding the same will be helpful

+2 votes
IDQ mapping output variables in workflow

How do you include you mapping output variables in the workflow without having to use a human task?

Basically I have one row of data that I want to push out and to be included in e.g. the body of the Notification task or as an attachment.

We are not using power center, only the developer tool.

+3 votes
Specifying Source file name using parameter variables in informatica 9?

I have a mapping like
SA-->SQ--->EXPR--->TGT

The source will be of the same structure and the tartget also.
There are a bunch of files(with the same structure) which will go through this mapping .
So i want to use a parameter file through which i will give the file names for every run manually.

How to use the param file in session for Source filename attribute
Please suggest..

...