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 |
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
why do u use shortcuts in informatica.?
What is Java Transformation? what are the uses of it?
How informatica recognizes mapping?
Please let me know how to make encryption and decryption with example?
How to join three sources using joiner?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Describe data concatenation?
How can we use batches?
The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?
I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com
What are the tasks that source qualifier perform?