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
Where is metadata stored?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the settings that you use to configure the joiner transformation?
What is the function of aggregator transformation?
what is diff b/t sorter t/r and agg have the option sorter property...
What does refresh system mean, and what are its distinctive choice?
How do we call shell scripts from informatica?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
-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?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How does a rank transform differ from aggregator transform functions max and min?
Mention few power centre client applications with their basic purpose?
Enlist the tasks for which source qualifier transformation is used.
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
What is meant by active and passive transformation?