Interested to Buy Any Domain ? << Click Here >> for more details...
Differentiate between mapping parameter and mapping variable?
- 1 Answers
- 1660 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
In informatics server which files are created during the session rums?
What is the meaning of decode in informatica?
with out using update strategy transnsformation how to update the data in mapping level
Where can we find the throughput option in informatica?
How to view and Generate Metadata Reports?
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
What are the different ways to implement parallel processing in informatica?
SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve
Difference between Target-based loading and constraint-based loading?
Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
Teradata 
