Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 13649 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
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
What is deployment group?
Explain pushdown optimization and types in informatica
What is rank transformation?
What is union transformation?
generate date / time dimension in informatica
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What's the layout of parameter file (what does a parameter file contain?)?
What is a filter transformation and why it is an active one?
Explain the different kinds of facts.
What is olap (on-line analytical processing?
Different qualification between a related rotate toward the sky and isolates look upward?
Separate from an archive server and a powerhouse?
How can we use mapping variables in informatica? Where do we use them?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What do mean by local and global repository?
