following scenario i have 1000 record flatfile source i
want ist row to ist target 2nd eow to 2nd target 3rd row to
3rd target how will u do?
Answer Posted / rakesh
use a Sequence Generator to generate a column NUM
in Router 1st Group: MOD(NUM,3)=1
2nd Group: MOD(NUM,3)=2
3rd Group: MOD(NUM,3)=0
Im not sure about MOD format, but this idea will workout..
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
Clarify the aggregator change?
What is Data Caches size?
What happens when a session fails and you click on recover?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is olap (on-line analytical processing?
Why sorter is an active transformation?
Briefly describe lookup transformation?
have u done any performance tuning? how u ll do?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Differentiate between Load Manager and DTM?
How can you differentiate between powercenter and power map?
How can a transformation be made reusable?
Does an informatica transformation support only aggregate expressions?
Explain what are the different versions of informatica?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.