I have a source either file or db table
Eno ename sal dept
101 sri 100 1
102 seeta 200 2
103 lax 300 3
104 ravam 76 1
105 soorp 120 2
Want to run a session 3 times.
First time: it should populate dept 1
Second time: dept 2 only
Third time: dept 3 only
How can we do this?
Answer Posted / raj
With the help of mapping variable.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Do you find any difficulty while working with flat files as source and target?
What is the need of etl tools?
what is mean by complex business rule ?
Briefly explain the aggregator transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
how to load dimension table and fact table. plz tell me the steps.
What can we do to improve the performance of informatica aggregator transformation?
Describe expression transformation?
How to create the source and target database connections in server manager?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is the advantage of informatica?
Explain how to import oracle sequence into informatica?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Which transformation is needed while using the Cobol sources as source definitions?
Write the prerequisite tasks to achieve the session partition?