Interested to Buy Any Domain ? << Click Here >> for more details...
we have 6 records in source , i need 2nd record in one
target and 5th record in one target or 2nd & 5th record in
same target.
- 8 Answers
- 12301 Views
- I also Faced
- E-Mail Answers
Answer Posted / sateesh
Source-->SQ-->SequenceGenerator-->Exp-->Rtr-->Target
In Exp Transformation assign a variable port like v_num=10;
In Rtr Transformation use defined group give a condition
like
IIF(curvar>1,IIF(Mod(v_num,curvar)=0,0,1),1)
Please correct me if am wrong.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is the difference between a connected look up and unconnected lookup?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is the meaning of up gradation of repository?
What are the databases that informatica can connect to windows?
Mention a few design and development best practices for informatica?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is an Integration service in Informatica?
Explain the different dimensions.
What is the cumulative sum and moving sum?
What do you mean by blocking transformation?
How to do unit testing in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Explain constraint based loading in informatica
In informatics server which files are created during the session rums?
What is sq transformation?
