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
- 10577 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 olap (on-line analytical processing?
can u give example for factless fact table
Is there any way to read the ms excel datas directly into informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the differences between source qualifier and joiner transformation?
What is sequence generator transformation in informatica?
What are the types of caches in lookup?
What is a shortcut and copy in Informatica and how two are different with each other?
What is option by which we can run all the sessions in a batch simultaneously?
Explain the scenario which compels informatica server to reject files?
How would you copy the content of one repository to another repository?
What are the measure objects?
can we override a native sql query within informatica? Where do we do it? How do we do it?
list out all the transformations which use cache?
How to Create a folder using pmrep command?
