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
How to delete duplicate row using informatica?
What do you mean by blocking transformation?
What is the command used to run a batch?
Explain direct and indirect flat file loading (source file type) - informatica
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
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is event and what are the tasks related to it?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How identifying bottlenecks in various components of informatica and resolving them?
Separate from a database, an information bazaar, and an information stockroom?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is the use of target designer?
Differentiate between router and filter transformation?
What is joiner transformation in informatica?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?