Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 7644 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / srinivas
create a mapping variable
example;
name type datatype pre scal agg
$variablename variable decimal 3 0 max
filter transformation
filter condition: setvariable($variablename,($variablename+1))
+1 is used as the consecutive deptno diff is 1
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
How do you manage the Parameter files while migrating your data from one environment to another environment?
how to load rows into fact table in data warehouse
What are the transformations that are not supported in mapplet?
Where is metadata stored?
Different circumstance which drives informatica server to expel records?
Explain the informatica workflow?
What is a connected transformation?
difference between repository database and repository service?
What does cheating measurement mean?
which one is better performance wise joiner or look up
What you know about transaction control transformation?
What is option by which we can run all the sessions in a batch simultaneously?
Which version configuration tool used in ur project?
Explain constraint based loading in informatica
What is decode in informatica?
