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
- 9635 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
Could you explain what is enterprise data warehouse?
What is a predefined event?
What is the session task and command task?
What is resilience time?
What is Session and Batches?
what is informatica metadata?
Which means the first record should come as last record and last record should come as first record and load into the target file?
How can we use mapping variables in informatica? Where do we use them?
How can you define user defied event?
Explain what are the different types of transformation available in informatica.
What is a shortcut and copy in Informatica and how two are different with each other?
What is enterprise data warehousing?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
can u give example for factless fact table
Explain the aggregator transformation?
