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
- 9783 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 validations that you can perform in oracle and in informatica ? Advance Thanks
What are the informatica performance improvement tips
How to generate sequence numbers without using the sequence generator transformation?
What is InformaticaPowerCenter?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is aggregator transformation in informatica?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Define the various join types of joiner transformation?
Explain the code page compatibility?
Please let me know how to make Data masking in informatica..
Have you worked with/created Parameter file
What do you mean by enterprise data warehousing?
How do you set a varible in incremental aggregation
What is the difference between source qualifier transformations source filter to filter transformation?
explain about unit testing? in real time?
