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
- 9909 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / guest
BY USING FIRST FUNCTION, TO GET THE 1ST RECORD,
TO GET THE LAST RECORD , SIMPLY USE AGGREGATE
TRANSFORAMATION IN THIS DO NOT APPLY GROUP BY FUNCTION BY
DEFALUT IT WILL GENERATE LAST RECORD
OR
USE RANK TRANS
IN =>PROPERTIES NO OF TOP RANKS:1
NO OF BOTTOM RANKS:LAST RECORD
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is xml source qualifier transformation in informatica?
What is sequence generator transformation in informatica?
What do mean by local and global repository?
can u any challenge your project?
Briefly define reusable transformation?
What does update strategy mean, and what are the different option of it?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Performance tuning in UNIX for informatica mappings?
What is the need of an ETL tool?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
lookup transformation with screenshots
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is aggregator transformation in informatica?
How to implement security measures using repository manager?
