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
What are the different transaction levels available in transaction control transformation?
is it possible to index the data in cache of lkp transformation ?
Tell me about Propagate functions in informatica
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is meant by incremental aggregation?
What is fact table? Explain the different kinds of facts.
How to use procedural logic inside infromatica?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How to use pmcmd utility command?
What are the informatica performance improvement tips
What are the popular informatica products?
tell me about your project functionality
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Explain what transformation and how many are there in informatica?