how can we load first and last record from a flat file
source to target?
Answer Posted / vinod saini
After sql Trans use AGG,JOINER transformation,and use FIRST
& LAST function in AGG transformation without any group.
FIRST & LAST return the first & Last record values. give
JOINER condition based on first & last.
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
What is sorter transformation?
define galaxy repository in informatica
How many input parameters can exist in an unconnected lookup?
How can you differentiate between powercenter and power map?
What are the new features of informatica 9.x in developer level?
What is joiner transformation in informatica?
How to do unit testing in informatica?
Explain the difference between mapping parameter and mapping variable?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What all are steps in up gradation of Informatica server?
What are pre and post-session shell commands?
what are 3 tech challenges/ common issues you face?
What is Cognos script editor?
Can we get 1st record through Informatica(without sequence number).
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?