Differentiate between mapping parameter and mapping variable?
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 |
How to compare Source and Target table, without using dynamic lookup?
explan ur project architecture?
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
Reusable transformation and shortcut differences
Explain about HLD and LLD ?
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
What are partitions in informatica and which one is used for better performance?
What is a poling?
What are mapping parametres and variables in informatica?
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
How can i set break points in debugging mode ? can explain steps please?
without using emailtask how will send a mail from informatica?