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 TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What are the types of schemas we have in data warehouse.
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is transformation?
What could be the possible resons of locks by user?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How many numbers of sessions can one group in batches?
How to handle decimal places while importing a flatfile into informatica?
hi real timers . iam waiting for ur reply regarding ETL TESTING
How does a rank transform differ from aggregator transform functions max and min?
where to store informatica rejected data? How to extract the informatica rejected data?
What is expression transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?
Why sorter is an active transformation?
What is workflow monitor?