How will you update the first four rows and insert next
four rows in a mapping?
- 5 Answers
- 9800 Views
- CTS, I also Faced
- E-Mail Answers
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 |
Without source how to insert record to target?
what is informatica metadata?
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.
Can you generate reports in Informatcia?
What is lookup change?
How to do the error handling of if ur source is flatfiles?
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
What are set operators in Oracle
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
how to load duplicate row in a target
Teradata 
