My i/p is 1,2,3,4,5,6,7,8,9,10………..
o/p to be populate in two tables as below.
o/p1: 10,20,30,40,50,60,70,80,90…….
o/p2: 11,21,31,41,51,61,71,881,91…….
Answer Posted / firdaus
src-->exp1-->target1
src-->exp2-->target2
In exp1 drag i/p port,then take o/p port
0/p=i/p||0
In exp2 drag i/p port,then take o/p port
0/p=i/p||1
thn link o/p ports of exp1 & exp2 to target1 & target2.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
How many ways are there to create ports?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is the use of an aggregator cache file?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Write the program through which the records can be updated?
What are the issues you have faced in your project? How did you overcome those issues?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Is there any target staging area in informatica not staging area
How can we improve session performance in aggregator transformation?
What is main use of mapplet?
What are the steps involved in the migration from older version to newer version of Informatica Server?
According to his methodology what all you need before you build a datawarehouse
lookup transformation with screenshots
How to delete duplicate row using informatica?