Differentiate between mapping parameter and mapping variable?
- 1 Answers
- 1218 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
What are the various types of transformation?
During the running session, output files are created by informatica server. Enlist few of them.
Explain the pipeline partition with real time example?
What are the different ways to implement parallel processing in informatica?
what is the size of your data warehousing?
What are the different components of powercenter?
Differentiate between reusable transformation and mapplet.
What is event and what are the tasks related to it?
Explain about Informatica server process that how it works relates to mapping variables?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
differences between service based and product based?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Explain sql transformation in script mode examples in informatica
Explain what is informatica metadata and where is it stored?
COM components can be used in Informatica
