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 / venkatesh.malneni
here we want to conform one thing that's is there serial no
or not
if there is serial no then we can just take a router then
create three(3) groups
First group for First target
Second is for second target
Third is for third target
write the condition as fallows
mod(s.no,3)=1-------> first target
mod(s.no,3)=2--------> second target
mod(s.no,3)=0-------->third target
if there is no s.no in source then create s.no by using
sequence generator t/r
the flow will be as fallows
/--------->t1
src--->sq---->router/----------->t2
\------------>t3
or if u use sequence generator the flow will be
sequqncegenerator
| /--------->t1
src--->sq---->router/----------->t2
\------------>t3
Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
How do you take back up of repository?
Define the various join types of joiner transformation?
Explain dynamic target flat file name generation in informatica
What is sorter transformation?
EXL informatica Questions
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is the need of etl tools?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How to do unit testing in informatica? How to load data in informatica ?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How can we delete duplicate rows from flat files?
Why do you use Mapping Parameter and mapping variable?
What is workflow? What are the components of the workflow manager?
How to do unit testing in informatica?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?