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

Where is metadata stored?

795


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

734


What are the settings that you use to configure the joiner transformation?

822


What is the function of aggregator transformation?

820


what is diff b/t sorter t/r and agg have the option sorter property...

1959


What does refresh system mean, and what are its distinctive choice?

786


How do we call shell scripts from informatica?

785


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3622


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5367


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1672


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

932


Mention few power centre client applications with their basic purpose?

735


Enlist the tasks for which source qualifier transformation is used.

787


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1838


What is meant by active and passive transformation?

813