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

How do you load only null records into target? Explain through mapping flow.

1789


Design time, run time. If you don't create parameter what will happen

1645


Explain the pipeline partition with real time example?

915


Which development components of informatica have the highest usage?

832


What is session task and command task?

882


What is the difference between a repository server and a powerhouse?

1192


Explian the Process of deployment groups in informatica

847


What are the different clients of powercenter?

839


What is the use of source qualifier?

902


Explain direct and indirect flat file loading (source file type) - informatica

1100


What are batches?

834


How we can use union transformation?

839


How to load the data from a flat file into the target where the source flat file name changes daily?

834


Partition, what happens if the specified key range is shorter and longer

2244


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1697