What is the difference Between Mapping parameter and variable
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 |
where is the reject loader .
Explian the Process of deployment groups in informatica
differences between service based and product based?
what is the monster dimension plz give me one example
normalizer transformation
how to insert header after each group.
How to enter same record twice in the target table,explain?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
How do you handle decimal places while importing a flatfile into informatica?
Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.
Why we use stored procedure transformation?
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?