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 can repository reports be accessed without sql or other transformations?
What is session task and command task?
how to load rows into fact table in data warehouse
What are the advantages of using informatica as an etl tool over teradata?
How can we improve session performance in aggregator transformation?
Which transformation is needed while using the Cobol sources as source definitions?
What is dimensional table?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is meant by query override?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What are the main features of Oracle 8i with context to datawarehouse?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How we can use union transformation?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?