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 / chandra
this can be done in two ways.....
1st one
after the SQ we can take EXP Tr
in EXP take one output port like O_SEQ
before EXP Tr take SGT Tr ...
In SGT properties enable cycling and
set START VAL 1 and END VAL 3
then connect the NEXVAL port into O_SEQ port of EXP Tr
after that take ROUTER Tr
in ROU Tr take 3 groups
1st group put condition as O_SEQ=1
2ns group O_SEQ=2 and
3 rd O_SEQ=3
and then drag the 1 st group data into TRG1
2nd group data into TRG2
and 3rd group data into TRG3
the fllow will be like
SRC--->SQ--->SGT--->EXP--->ROU-->TRG1
---> TRG2
--->TRG3
or
we can use MOD function in EXP Tr we can done this
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What are the issues you have faced in your project? How did you overcome those issues?
How an expression transformation differs from aggregator transformation?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What do you mean by worklet?
Explain incremental aggregation in informatica
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is an expression transformation?
What are the new features of informatica 9.x at the developer level?
wat are deployement groups in informatica, how it will be used for developers
What is meant by incremental aggregation?
What is meant by a domain?
What is Data Caches size?
Explain what transformation and how many are there in informatica?
What are pre and post-session shell commands?
Enlist the tasks for which source qualifier transformation is used.