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 / janardhan

Hi Guys, I need sql query for the above functionality.
I mean sql query to get last record from 10 records same like aggregator transformation in informatica which gives last record if we don't give any group by.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Briefly define reusable transformation?

850


How can repository reports be accessed without sql or other transformations?

965


How we can use union transformation?

812


What is meant by active and passive transformation?

813


What is a joiner transformation and why it is an active one?

781


What is an active transformation?

846


Explain sessions?

779


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1379


can anyone suggest best free Talend data integration training online

1483


Explain how many types of dimensions are available in informatica?

782


What is a shortcut and copy in Informatica and how two are different with each other?

937


What is meant by pre and post session shell command?

866


Slowly changing dimensions, types and where will you use them

1478


What is expression transformation?

834


what is the difference between informatica6.1 and infomatica7.1

1929