Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference Between Mapping parameter and variable
- 3 Answers
- 10389 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 |
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
Flat file heaving 1 lack records and I want to push 52000 records to the target?
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
how to get flatfile containg 10 records half records one target another half another target
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
i want excute multiple sessions in one workflow using the "start task".what do i need to do?
How many cubes create from a single model?
Explain about the concept of mapping parameters and variables ?
hw cn v elimate dublicate values from lookup without overriding sql?
How to join three sources using joiner? Explain though mapping flow.
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
Teradata 
