in my source i have 100 records, and 3 targets, i want to
load
1st record into 1st target,2nd record into 2nd target,3rd
record into 3rd target again 4th target into 1st target and
vice versa,how to achieve this?
Answer Posted / ankur saini er.ankur861@gmail.
i think the best way to achieve this is to add a cyclic
sequecn gen which will gen 1,2,3 again 1,2,3 again 1,2,3
addd a router then or 3 filters add dump the the data from
sep filters or router groups to the diff targets as
required..
Thanks...
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Suppose we do not group by on any ports of the aggregator what will be the output?
How we can create indexes after completing the loan process?
What is the cumulative sum and moving sum?
What the difference is between a database, a data warehouse and a data mart?
How to elaborate tracing level?
What do you understand by a term domain?
What is expression transformation?
How will the document be delivered to me?
What is aggregate cache in aggregator transformation?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
how we can load rejected record's at run time?(not through bad files)
Is it possible to create multiple domains on a single Informatica server?
Enlist some properties of sessions.
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What are the settings that you use to configure the joiner transformation?