How will you update the first four rows and insert next
four rows in a mapping?
- 5 Answers
- 9446 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
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Which transformation is needed while using the Cobol sources as source definitions?
Why filter transformation is an active one?
How to load data in informatica ?
Explain sessions?
How do you set a varible in incremental aggregation
what is mean by complex business rule ?
my source is junk data how will u remove that junk data by using unix please any one replay me
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What are the different components of powercenter?
What is dimensional table?
Define mapplet?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
