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


Please Help Members By Posting Answers For Below Questions

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1862


What is resilience time?

846


what is the -ve test case in your project.

2118


What is transformation?

881


How identifying bottlenecks in various components of informatica and resolving them?

862


What do you mean by filter transformation?

759


How can we create index after completion of load process?

839


Write the unconnected lookup syntax and how to return more than one column.

841


Explain what are the different types of transformation available in informatica.

788


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?

1254


What is difference between a gateway node and worker node?

870


What is sorter transformation?

786


What are the static cache and dynamic cache in informatica?

976


can u any challenge your project?

1799


How to partition the Session?

852