Interested to Buy Any Domain ? << Click Here >> for more details...
What are mapping parametres and variables in informatica?
- 6 Answers
- 35280 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 the different lookup cache(s)?
What are the performance considerations when working with aggregator transformation?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How to convert multiple rows to single row (multiple columns) in informatica
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What are the mapping parameters and mapping variables?
What is deployment group?
r u done any partitions in ur project?
What is the cumulative sum and moving sum?
Define the various join types of joiner transformation?
What is the benefit of session partitioning?
explain abt ur project architecture?
Enlist few areas or real-time situations where informatica is required.
What could be the possible resons of locks by user?
Clarify the utilization of aggregator cache record?
