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
- 7541 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 we can load rejected record's at run time?(not through bad files)
Is it possible to create multiple domains on a single Informatica server?
How can we remove the duplicates from flat file source?
Explain how to import oracle sequence into informatica?
How can you validate all mappings in the repository simultaneously?
How do you handle two sessions in Informatica
How do you load unique records into one target table and duplicate records into a different target table?
What is a code page?
State the differences between sql override and lookup override?
Enlist the tasks for which source qualifier transformation is used.
What is sorter transformation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What does refresh system mean, and what are its distinctive choice?
What is a standalone command task?
Is it possible to revert a global repository to local one and why?
