Interested to Buy Any Domain ? << Click Here >> for more details...
Differentiate between mapping parameter and mapping variable?
- 1 Answers
- 1623 Views
- I also Faced
- E-Mail Answers
Answer Posted / ysindhureddy77@gmail.com
A mapping parameter is a user definable constant that takes up a value before running a session. It can be used in SQ expressions, Expression transformation etc.
A mapping variable is also defined similar to the parameter except that the value of the variable is subjected to change. It picks up the value in the following order.
From the Session parameter file
As stored in the repository object in the previous run
As defined in the initial values in the designer
Data type Default values
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
hi real timers . iam waiting for ur reply regarding ETL TESTING
permutations of mapplet
what are 3 tech challenges/ common issues you face?
What are the different options available for update strategy?
How do you load unique records into one target table and duplicate records into a different target table?
How to load last n records of file into target table - informatica
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
As union transformation gives UNION ALL output, how you will get the UNION output?
Explain transaction control transformation in informatica
What are the main issues while working with flat files as source and as targets ?
How can we create index after completion of load process?
What are the informatica performance improvement tips
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What are the static cache and dynamic cache in informatica?
