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
- 10881 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 domain in terms of informatica?
can anyone explain me about retail domain project in informatica?
Explain the pipeline partition with real time example?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
In which transformation you cannot drag ports into it?
How many dimensions are there in informatica?
Explain the etl program with few examples.
What is the meaning of up gradation of repository?
What is resilience time?
What is meant by query override?
What is joiner change?
How many input parameters can exist in an unconnected lookup?
Why update strategy and union transformations are active?
generate date / time dimension in informatica
Is it possible to define a single node as a Gateway node as well as worker node?
