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
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is the advantage of informatica?
what is diff b/t sorter t/r and agg have the option sorter property...
generate date / time dimension in informatica
Mention some types of transformation?
Explain the scenario which compels informatica server to reject files?
What is confirmed fact in dataware housing?
What are the differences between a connected lookup and unconnected lookup?
What are the features of complex mapping?
What is a surrogate key?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What do you understand by SOA of Informatica?
What is mapping debugger?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is the maplet?