Interested to Buy Any Domain ? << Click Here >> for more details...
My source table having some records ,i want load 1st record
and last record into one target?
- 3 Answers
- 9808 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / kiran
take two rank transformations and take reusable sequence
generator connect the next value to both rank transformations
and in the rank transformations properties for the first one
take top and number of ranks as 1 for the second take bottom
and number of ranks 1 at the last take two instances of tgt
connect the ranktrans to two instances
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the new features of Power Center 5.0?
What do you mean by blocking transformation?
How to generate sequence numbers?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is meant by lookup transformation?
How do you load unique records into one target table and duplicate records into a different target table?
explain about unit testing? in real time?
Define filter transformation?
What is rank transformation?
can we override a native sql query within informatica? Where do we do it?
What is dimensional table? Explain the different dimensions.
How to do unit testing in informatica? How to load data in informatica ?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
what is SDLC way of code development?
