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
EXL informatica Questions
Where do we use mapping variables in informatica?
what are the deliverables?in your project?
Explain the informatica workflow?
Where can we find the throughput option in informatica?
How do you load first and last records into target table?
What are different types of transformations available in informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
what is the -ve test case in your project.
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How can you validate all mappings in the repository simultaneously?
What is a filter transformation?
Explain in detail scd type 2 through mapping.
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are the designer tools for creating transformations?