Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10297 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
Explain the aggregator transformation?
What do you mean by blocking transformation?
Sequence generator, when you move from develoment to production how will you reset
Which development components of informatica have the highest usage?
What are ETL Tools?
What is the need for an etl tool?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is meant by lookup transformation? Explain the types of lookup transformation?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What all join we can perform in LOOKUP transformation?
Why filter transformation is an active one?
What are some examples of informatica etl programs?
How to load last n records of file into target table - informatica
How to generate sequence numbers using expression transformation?
