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

Dont use group by.By default it will give last row.To
override it,use FIRST function.

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a sorter transformation?

898


What are the informatica performance improvement tips

842


What do you mean by channel change?

775


explan ur project architecture?

1850


Why update strategy and union transformations are active?

825


What is informatica worklet?

807


How do you set a varible in incremental aggregation

1666


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1852


What is data movement mode in Informatica and difference between them?

875


How can you define user defied event?

834


How to load the data from a flat file into the target where the source flat file name changes daily?

825


Explain the features of connected and unconnected lookup.

747


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

799


Explain the use of aggregator cache file?

946


Describe data concatenation?

818