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 the difference between a repository server and a powerhouse?
How do you use reject loader.
In which transformation you cannot drag ports into it?
What do you mean by channel change?
Can anyone tell me the new features in Informatica 9 Version?
What is meant by query override?
Is it possible to create multiple domains on a single Informatica server?
What are the popular informatica products?
Is there any target staging area in informatica not staging area
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How to elaborate tracing level?
What is intricate mapping?
What is the status code in stored procedure transformation?
Define mapping and session?