How will you update the first four rows and insert next
four rows in a mapping?
Answers were Sorted based on User's Feedback
Answer / shyam
from source qualifier trf take a exp trf with a sequence gen
and from there give it to filer trf. write there a condition
next value<=4 and give it to update stategy trk. and there
give condion as dd_insert and then to targer,this all comes
in first pipeline.
in second pipeline drag the ports from exp trf and again
take a filter trf,over there give condion as next_val>4 and
next_val<9. give this to update trf and then to targer.
try this .i hope u vl get the o/p.
if im wrong plz let me know
shaym
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / tejal
We can use an expression transform after the source quailifier - define a variable / counter port and increment it for each run.
Output this counter value and pass it to a router , which has 2 groups based on this value counter <=4 then insert else update.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / vali
i can explain it more clear that we have to place a rank
t/r before router and create two groups in router and given
it to update strategy....
src->sq->rank->router->ups->trg
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / srini
generate sequence number and use mod function in router t/r.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / adisekhar
->->UPS->TAR
MAPPING DIAGRAM LIKE SRC->SQL->RTR->
->UPS->TAR
Is This Answer Correct ? | 1 Yes | 3 No |
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
What are the parts of Informatica Server?
How to extract original records at one target & Duplicate records at one target?
Reusable transformation and shortcut differences
Where is the cache stored in informatica?
Define pmcmd command?
What are the different ways to implement parallel processing in informatica?
When you move from devel to prod how will you retain a variable
what are the real time problems generally come up while doing or running mapping or any transformation?
Why use shortcuts(Instead of making copies).
what are presession,postsession success and postsession failure commands ?
Label in Informatica. How to remove existing Label.