What are mapping parametres and variables in informatica?
Answer Posted / bsgsr
mapping parameters and variables make the mappings reusable
and saves time. ex: u have created a mapping to load the
data of only deptno 10 into the target. next time if you
want to load the data of deptno 20 u have to create the
mapping again which is fom the scratch again. if you create
a parameter and define the value in the parameter file you
can simply change the value of the parameter and can use
the mapping again.
mapping parameter represents a constant value that doesnt
change during the session run where as mapping variable
represents a value which changes during the session run
and saves the max value to the repository which is used
next time when you run the session.
Is This Answer Correct ? | 36 Yes | 2 No |
Post New Answer View All Answers
what is mean by complex business rule ?
Why filter transformation is an active one?
How to partition the Session?
What is flashback table ? Advance thanks
How many number of sessions can one group in batches?
Whats there in global repository
What happens when a session fails and you click on recover?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain load alternative records / rows into multiple targets - informatica
What do you understand by a term domain?
Implementation methodology
What is meant by query override?
Can we get 1st record through Informatica(without sequence number).
What is olap (on-line analytical processing?
Informatica Checkpoints