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 |
What are the differences between oltp and olap?
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
What is informatica powercenter repository?
Why we use ENABLE HIGH PRECISION in session properties?
What are data-driven sessions?
If we are using an aggregator but forget to mention the group by port .what will be the output??
How can you differentiate between powercenter and power map?
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me
A session S_MAP1 is in Repository A. While running the session error message has displayed