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
What is a sorter transformation?
What are the informatica performance improvement tips
What do you mean by channel change?
explan ur project architecture?
Why update strategy and union transformations are active?
What is informatica worklet?
How do you set a varible in incremental aggregation
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is data movement mode in Informatica and difference between them?
How can you define user defied event?
How to load the data from a flat file into the target where the source flat file name changes daily?
Explain the features of connected and unconnected lookup.
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??
Explain the use of aggregator cache file?
Describe data concatenation?