if we hav 10 records in a file, can we get first record from
it by using Aggregator with out using Groupby Port in it?If
Yes..let me know the answer plz!!!
Answer Posted / venkat
Yes, we can get first record using aggregator below are the
steps:
First need to sort all the records by desc and connect to
aggregator transformation than connect to target without
using gropby port than you will get first record.
Ask me any questions to <ittoolboxdwh@gmail.com> this is my
mailid.
Cheers
Venkat.
Is This Answer Correct ? | 6 Yes | 9 No |
Post New Answer View All Answers
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is resilience time?
what is the -ve test case in your project.
What is transformation?
How identifying bottlenecks in various components of informatica and resolving them?
What do you mean by filter transformation?
How can we create index after completion of load process?
Write the unconnected lookup syntax and how to return more than one column.
Explain what are the different types of transformation available in informatica.
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is difference between a gateway node and worker node?
What is sorter transformation?
What are the static cache and dynamic cache in informatica?
can u any challenge your project?
How to partition the Session?