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
To import the flat file definition into the designer where should the flat file be placed?
What do you understand by a term domain?
How identifying bottlenecks in various components of informatica and resolving them?
How do you load alternate records into different tables through mapping flow?
Performance tuning( what you did in performance tuning)
Suppose we do not group by on any ports of the aggregator what will be the output?
What are the new features of informatica 9.x in developer level?
what is the size of u r source(like file or table)?
In development project what is the process to follow for an etl developer from day1
Briefly define a session task?
Briefly explain the aggregator transformation?
Quickly characterize reusable change?
What is the surrogate key?
Which is the t/r that builts only single cache memory?
What is dimensional table? Explain the different dimensions.