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
How can you validate all mappings in the repository simultaneously?
update strategy transformation in informatica
What is informatica powercenter repository?
What is meant by query override?
How to create or import flat file definition in to the warehouse designer?
How can we use batches?
Make a note of the quantity vaults made in informatica?
what are 3 tech challenges/ common issues you face?
How do you promote a non-reusable transformation to reusable transformation?
What is mapplet in informatica?
Can we create multiple integration service on single repository?
What is a passive transformation?
How you can differentiate between connected lookup and unconnected lookup?
Mention some types of transformation?
What is substr in informatica?