One source and 3 targets
1st row-1st target
2nd row-2nd target
3rd row-3rd target
4th row-1ist target how will u do?
Answer Posted / usha
By using Sequence Generator transformation.
in Sequence Generator transformation we shoud set
start value =1
cycle should enable
end value = 3
increment value=1
in router we should give condion as
next value=1 for 1st group
next value=2 for 2nd group
next value=3 for 3rd group
S-->SQ--> seq-->rout--> Target1
Target2--> Target3
Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
whats the logic to load the lower level of granularity of data to fact table.
Please let me know how to make Data masking in informatica..
is it possible to index the data in cache of lkp transformation ?
What is session task and command task?
What is the difference between STOP and ABORT options in Workflow Monitor?
What is Cognos script editor?
What is dimensional table?
What is a pre-defined event and user-defined event?
What is workflow? What are the components of the workflow manager?
Is it possible to create multiple domains on a single Informatica server?
What is the difference between writing a joiner query in ANSI style and THETA style?
Performance tuning in UNIX for informatica mappings?
Explain constraint based loading in informatica
What is sequence generator transformation in informatica?