Interested to Buy Any Domain ? << Click Here >> for more details...
What are mapping parametres and variables in informatica?
- 6 Answers
- 35865 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 workflow? What are the components of workflow manager?
What are the main features of Oracle 8i with context to datawarehouse?
Differentiate between Load Manager and DTM?
What are the types of caches in lookup? Explain them.
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
wat are deployement groups in informatica, how it will be used for developers
what are factless facts? And in which scenario will you use such kinds of fact tables.
Explain constraint based loading in informatica
What are the static cache and dynamic cache in informatica?
When do you use sql override in a lookup transformation?
Sequence generator, when you move from develoment to production how will you reset
Is there any way to read the ms excel datas directly into informatica?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Explain sessions and how many types of sessions are there?
What is the use of transformation?
