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 meant by lookup transformation? Explain the types of lookup transformation?

746


How to do unit testing in informatica? How to load data in informatica ?

888


Difference between Data and Index Caches?

873


What is lookup change?

822


What is the command used to run a batch?

776


How to create the source and target database connections in server manager?

827


What are the types of schemas we have in data warehouse.

733


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

964


How do you update the records with or without using update strategy?

889


Explain why we use partitioning the session in informatica?

807


explain abt ur project architecture?

1931


What are ETL Tools?

854


What is the cumulative sum and moving sum?

962


What is informatica? Why do we need it?

854


What are different types of transformations available in informatica?

756