Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference Between Mapping parameter and variable
- 3 Answers
- 10572 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / siva
In additon to the Abhinav answer, Once value assigned to
mapping parameter, it can not be change as per login in
mapping.
Where as if you define as mapping variable, it can be
initialized, can be changed the value as per logic in
mapping and even it can be held as persistent to use the
same value in running session next time.
I think you understand this..
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / abhinav
Mapping parameter is an option in Informatica where, at the
mapping level, you can specify the value to be used.
For example, if there is a field called START_DATE, the
value for this date can be specified by either passing it
as a variable at the mapping level or storing the value in
a parameter file, which will be read during the session is
run.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sankar
mapping parameter: maping parameter is a constent value
that can be defin before maping run
A mapping parameter reuse the mapping for various constant
value.
mapping variable:mapping vareable is represent a value that
can be change during the mapping run
that can be stored in reposatry the integartion service
retrive that value frm repositary and incremental value for
next run
| Is This Answer Correct ? | 2 Yes | 1 No |
what is diff between IN and EXIT commands
What is intricate mapping?
What is meant by incremental aggregation?
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
Do you have to change the reject file b4 using reject loader utility.
What are the types of maping wizards that r to be provided in Informatica?
What is a sequence generator transformation?
What are the data movement modes in informatcia?
i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc
what is the diff b/w cached and unchaed look ups
How can we use mapping variables in informatica? Where do we use them?
Explain what are the different versions of informatica?
Teradata 
