Interested to Buy Any Domain ? << Click Here >> for more details...
What are mapping parametres and variables in informatica?
- 6 Answers
- 35617 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
scenario where i can use only concurrent execution of workflow.
What is the use of code page?
Is it possible to use a client with different version than that of its Informatica server?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Briefly explain the aggregator transformation?
design of staging area?
How to start a workflow using pmcmd command?
what is index?how it can work in informatica
How to elaborate tracing level?
What is substr in informatica?
What is a pre-defined event and user-defined event?
What does refresh system mean, and what are its distinctive choice?
Explain the informatica workflow?
What is decode in informatica?
When do you use sql override in a lookup transformation?
