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
How do you load only null records into target? Explain through mapping flow.
Design time, run time. If you don't create parameter what will happen
Explain the pipeline partition with real time example?
Which development components of informatica have the highest usage?
What is session task and command task?
What is the difference between a repository server and a powerhouse?
Explian the Process of deployment groups in informatica
What are the different clients of powercenter?
What is the use of source qualifier?
Explain direct and indirect flat file loading (source file type) - informatica
What are batches?
How we can use union transformation?
How to load the data from a flat file into the target where the source flat file name changes daily?
Partition, what happens if the specified key range is shorter and longer
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