Differentiate between mapping parameter and mapping variable?
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
Informatica settings are available in which file?
Enterprise data warehouse your projects phase by phase explain?
Which transformation should we use to normalise the COBOL and relational sources?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How are indexes created after completing the load process?
What is DR strategy for Informatica project?
What are the types of presistent cache in look up tr.
write a query to retrieve the latest records from the table sorted by version(scd)
Explain pushdown optimization $pushdownconfig parameter - informatica
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Design time, run time. If you don't create parameter what will happen
What all are steps in up gradation of Informatica server?
What is an unconnected transformation?
Explain how to import oracle sequence into informatica?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance