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
How do you load alternate records into different tables through mapping flow?
Plz can any one say me how to get the informatica certification materials and dumps
Explain joiner transformation in informatica
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How you prepared reports for OLAP?
How to elaborate tracing level?
Explain about cumulative Sum or moving sum?
What are session parameters ? How do you set them?
Explain direct and indirect flat file loading (source file type) - informatica
What happens when a session fails and you click on recover?
What are the different types of repositories created using informatica?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Whats there in global repository
What are the popular informatica products?
How to differentiate between the active and passive transformations?