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
- 9793 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
-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?
How can one identify whether mapping is correct or not without connecting session?
can anyone suggest best free Talend data integration training online
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Write the advantages of partitioning a session?
How many transformations can be used in mapplets.
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What are the various types of transformation?
What is a sequence generator transformation?
What is a repository? And how to add it in an informatica client?
Enlist the tasks for which source qualifier transformation is used.
What is parallel processing in informatica?
How can we remove the duplicates from flat file source?
What are the differences between joiner transformation and source qualifier transformation?
what is $$$$?
