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
Explain lookup transformation in informatica
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How you prepared reports for OLAP?
What is blocking transformation?
What do you mean by channel change?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Mention few power centre client applications with their basic purpose?
pmscmd startworkflow -sv
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Differentiate between a database and data warehouse?
how to load rows into fact table in data warehouse
What is fact table? Explain the different kinds of facts.
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.
what is the complex transformation you used in informatica
What is the difference between a connected look up and unconnected lookup?