Hi Guys, I need sql query for the above functionality. I mean sql query to

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!!!

Question Posted / janardhan

8 Answers
29078 Views
IBM, I also Faced
E-Mail Answers

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

What are pre and post-session shell commands?

1231

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1439

Parameter and variable differences

2002

Explain the scenario which compels informatica server to reject files?

1084

Where can we find the throughput option in informatica?

995

what is SDLC way of code development?

1966

How to use pmcmd utility command?

959

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1727

What does reusable transformation mean?

1066

How to delete duplicate row using informatica?

981

What are the different ways to implement parallel processing in informatica?

1338

How to load data in informatica ?

950

can we override a native sql query within informatica? Where do we do it?

1065

Enlist the tasks for which source qualifier transformation is used.

980

How to generate sequence numbers?

1025