My source table having some records ,i want load 1st record
and last record into one target?
- 3 Answers
- 9129 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 is informatica powercenter repository?
Plz can any one say me how to get the informatica certification materials and dumps
What is sequence generator transformation in informatica?
What are roles and groups and benefits of using them?
Why do you use Mapping Parameter and mapping variable?
Differentiate between joiner and lookup transformation?
How can you increase the performance in joiner transformation?
Define Pmrep command?
How do you convert single row from source into three rows into target?
What is sorter transformation?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How to use pmcmd utility command?
Describe expression transformation?
What is the use of code page?
What are the popular informatica products?
