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
- 7399 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
can u any challenge your project?
Parameter and variable differences
What is the way to execute pl/sql script using informatica mapping?
what are the Methods For Creating Reusable Transformations?
What can we do to improve the performance of informatica aggregator transformation?
Where do we use mapping variables in informatica?
What differs when we choose the sorted input for aggregator transformation?
Why sorter is an active transformation?
What are active and passive transformations?
What do you understand by SOA of Informatica?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is dimensional table? Explain the different dimensions.
What is session task and command task?
Explain lookup transformation is active in informatica
What is olap (on-line analytical processing?
