How will you update the first four rows and insert next four rows in a mapping

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

How will you update the first four rows and insert next
four rows in a mapping?

Question Posted / radhakrishnansk

5 Answers
11081 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How will you update the first four rows and insert next four rows in a mapping?..

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

How will you update the first four rows and insert next four rows in a mapping?..

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

How will you update the first four rows and insert next four rows in a mapping?..

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

How will you update the first four rows and insert next four rows in a mapping?..

Answer / srini

generate sequence number and use mod function in router t/r.

Is This Answer Correct ?

1 Yes

0 No

How will you update the first four rows and insert next four rows in a mapping?..

Answer / adisekhar

->->UPS->TAR
MAPPING DIAGRAM LIKE SRC->SQL->RTR->
->UPS->TAR

Is This Answer Correct ?

1 Yes

3 No

Post New Answer