I Have 100 Records in a relational tble and i want to load
the record in 3 targets , first records goes to target 1
and second to target 2 and third to target 3 and so
on ,what are the tx used in this and what are the
logics ,can any one help me ?? Thanks in Advance
Answer Posted / srinivas
I had another simple solution ...
1.use router transforamation .. generate 3 groups and use
sequence generator ... next value connnct to router
transformation... and logic is
mod(next,3)=1,mod(next,3)=2,mod(next,3)=0,,
connct to 3 targets load it...
Is This Answer Correct ? | 21 Yes | 4 No |
Post New Answer View All Answers
How to start a workflow using pmcmd command?
Parameter and variable differences
write a query to retrieve the latest records from the table sorted by version(scd)
Difference between Data and Index Caches?
What is a router transformation?
How can we remove the duplicates from flat file source?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
In which transformation you cannot drag ports into it?
What is parallel processing in informatica?
Different circumstance which drives informatica server to expel records?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
How to load a Dimension ? and how to load a fact table?
How identifying bottlenecks in various components of informatica and resolving them?
What do you mean by filter transformation?
Why union transformation is an active transformation?