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
- 7556 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
Explain the difference between mapping parameter and mapping variable?
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
Describe two levels in which update strategy transformation sets?
connected and unconnected lookups?
Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation
 Informatica Checkpoints
how to convert the .doc docs into .txt format using informatica
What are the ETL tools available in DWH?
why we use informatica in our project?
what is index?how it can work in informatica
Teradata 
