Interested to Buy Any Domain ? << Click Here >> for more details...
How will you update the first four rows and insert next
four rows in a mapping?
- 5 Answers
- 10865 Views
- CTS, I also Faced
- E-Mail Answers
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 intricate mapping?
I have a flat file, want to reverse the contents of the flat file
Explain pushdown optimization $pushdownconfig parameter - informatica
Why do we need informatica?
What is the benefit of partitioning a session?
What do mean by local and global repository?
What is a predefined event?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What does reusable transformation mean?
Explain target update override in informatica
What is sorter transformation?
what is the size of your data warehousing?
what is informatica metadata?
How to elaborate tracing level?
what is diff b/t sorter t/r and agg have the option sorter property...
