Interested to Buy Any Domain ? << Click Here >> for more details...
i have flat file it contains 'n' number of records, i need
to send half of the records to one target table and
Remaining half to another target table: pls full details
- 8 Answers
- 18520 Views
- L&T, TCS, UnitedHealth Group, Wipro, I also Faced
- E-Mail Answers
Answer Posted / mike
target1
src-->sq-->seq gen-->rtr--> /
\
target 2
drag the source. create an sequence generator
transformation and then pass all the data to router create
two groups in the router transformation pass it to
target...You can give the condition in the router
transformation based on your requirement. if it is like odd
and even...you can use mod function in the router
transformation.
Mod function returns 0 passit to t2 and mod function
returns 1 pass it to t1
hope this works...correct me if i was wrong
| Is This Answer Correct ? | 3 Yes | 13 No |
Post New Answer View All Answers
lookup transformation with screenshots
Can informatica load heterogeneous targets from heterogeneous sources?
can we override a native sql query within informatica? Where do we do it?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What are active transformations.
How can a transformation be made reusable?
What is the difference between Active and Passive transformation?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What do you mean incremental aggregation?
What is pmcmd command?
Explain direct and indirect flat file loading (source file type) - informatica
What is the sequence generator transformation in informatica?
Informatica settings are available in which file?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
