How will you update the first four rows and insert next
four rows in a mapping?
Answer Posted / 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 |
Post New Answer View All Answers
What is the command used to run a batch?
What is a pre-defined event and user-defined event?
Briefly define reusable transformation?
What is the benefit of session partitioning?
What is Session and Batches?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What are the features of complex mapping?
What is the status code in stored procedure transformation?
Does an informatica transformation support only aggregate expressions?
What is informatica worklet?
How can a transformation be made reusable?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How you prepared reports for OLAP?