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


Please Help Members By Posting Answers For Below Questions

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1704


What are the types of schemas we have in data warehouse.

749


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1941


What is transformation?

897


What could be the possible resons of locks by user?

881


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1860


How many numbers of sessions can one group in batches?

843


How to handle decimal places while importing a flatfile into informatica?

975


hi real timers . iam waiting for ur reply regarding ETL TESTING

2058


How does a rank transform differ from aggregator transform functions max and min?

947


where to store informatica rejected data? How to extract the informatica rejected data?

808


What is expression transformation?

869


What is the difference between writing a joiner query in ANSI style and THETA style?

2165


Why sorter is an active transformation?

981


What is workflow monitor?

823