Interested to Buy Any Domain ? << Click Here >> for more details...
What are mapping parametres and variables in informatica?
- 6 Answers
- 35357 Views
- TCS, I also Faced
- E-Mail Answers
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 rank transformation?
what is Active lock explain
what is the difference between informatica6.1 and infomatica7.1
What is a rank transform?
What all are steps in up gradation of Informatica server?
Explain constraint based loading in informatica
What is meant by incremental aggregation?
What are the different types of olap? Give an example?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How to improve the performance of a session using sorter transformation?
Briefly explain the aggregator transformation?
Is stop and abort are same in informatica?
What are pre and post-session shell commands?
How can we handle two sessions in informatica?
Can informatica load heterogeneous targets from heterogeneous sources?
