Interested to Buy Any Domain ? << Click Here >> for more details...
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!!!
- 8 Answers
- 29097 Views
- IBM, I also Faced
- E-Mail Answers
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
Briefly define reusable transformation?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is an aggregator transformation?
What is a standalone command task?
Explain the types of lookup transformation?
differences between service based and product based?
what is the -ve test case in your project.
What are the different types of olap? Give an example?
What is the use of transformation?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
can you please explain me pre session and post session options?
Separate from a database, an information bazaar, and an information stockroom?
how we can load rejected record's at run time?(not through bad files)
What are the databases that informatica can connect to windows?
How to Create a folder using pmrep command?
