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

Explain lookup transformation in informatica

852


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

908


How you prepared reports for OLAP?

1372


What is blocking transformation?

929


What do you mean by channel change?

782


While importing the relational source definition from the database, what are the metadata of source that will be imported?

1056


Mention few power centre client applications with their basic purpose?

749


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?

1304


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

874


Differentiate between a database and data warehouse?

922


how to load rows into fact table in data warehouse

919


What is fact table? Explain the different kinds of facts.

819


Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2629


what is the complex transformation you used in informatica

2408


What is the difference between a connected look up and unconnected lookup?

780