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?
- 7 Answers
- 8505 Views
- Polaris, I also Faced
- E-Mail Answers
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
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Mention some types of transformation?
How to join three sources using joiner?
which one is better performance wise joiner or look up
What is event and what are the tasks related to it?
What is the difference between a connected look up and unconnected lookup?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Explain dynamic target flat file name generation in informatica
What is a surrogate key?
How can we delete duplicate rows from flat files?
What is aggregator transformation in informatica?
What are the types of lookup transformation?
What is decode in static cache?
Can anyone tell me the new features in Informatica 9 Version?
