Explain the mapping variable usage example in informatica
- 1 Answers
- 1262 Views
- Informatica, I also Faced
- E-Mail Answers
Answer / Lalitendra Singh Rana
Mapping variables can be used to pass dynamic runtime values from one transformation to another or from one session to another session. Here is an example of a simple mapping variable usage in Informatica:nnFirst, define a mapping variable called 'counter' with a default value of 0.nNext, within a transformation, increment the counter by 1 using an expression transformation:n```expressionncounter = counter + 1;n```nFinally, pass the counter to the next session or transformation and use it there as needed.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is shared lookup&persistent lookup?
4 Answers Accenture, Cap Gemini,
What does refresh system mean, and what are its distinctive choice?
how we can update a target table without update strategy and update override?
if i am having 10 records in source, i want 20 records in target...how will you do it
What is Performance tuning in Informatica?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
Where do you create/define mapping parameter and mapping variable?
How do you set a varible in incremental aggregation
Tell me about informatica architecture.
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Explain the informatica workflow?
Teradata 
