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
- 7532 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
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What are Dimensional table?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Differences between connected and unconnected lookup?
Quickly characterize reusable change?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Do you find any difficulty while working with flat files as source and target?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
Implementation methodology
How to do the error handling of if ur source is flatfiles?
Which transformation is needed while using the Cobol sources as source definitions?
How we can create indexes after completing the load process?
draw informatica architecture 8.6 ?
what is Active lock explain
What is the commit type if you have a transaction control transformation in the mapping?
