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 do you mean by worklet?
What is an expression transformation?
During the running session, output files are created by informatica server. Enlist few of them.
what is SDLC way of code development?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is meant by incremental aggregation?
Briefly describe lookup transformation?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is the commit type if you have a transaction control transformation in the mapping?
What do you understand by SOA of Informatica?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How would you copy the content of one repository to another repository?
Why do you use Mapping Parameter and mapping variable?
Mention few power centre client applications with their basic purpose?