How will you update the first four rows and insert next
four rows in a mapping?
- 5 Answers
- 9857 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
Define joiner transformation?
What is a node in Informatica?
What are the static cache and dynamic cache in informatica?
Tell me about Propagate functions in informatica
What is an expression transformation in informatica?
According to his methodology what all you need before you build a datawarehouse
Explain your project of banking domian.
What are the limitations of joiner transformation?
Describe data concatenation?
What are the advantages of using informatica as an etl tool over teradata?
What is a code page?
What are the different versions of informatica?
What is a snowflake schema?
What is lookup change?
if we have a delimiters at unwanted places in a flat file how can we over come those.
