IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL
USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT
WILL TAKE ONLY THE LAST COLUMN WHY????
Answer Posted / amedela chandra sekhar
Aggregator t/r perform calculations from first record to
last record.There is no group it will take last record
if u are not selected groupby the integration service returns
last record from all input rows.
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Briefly explain the aggregator transformation?
What are the features of complex mapping?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What are the databases that informatica can connect to windows?
Explain pmcmd command usage in informatica
Describe expression transformation?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is the maplet?
What are session parameters ? How do you set them?
How to generate sequence numbers?
What is an expression transformation in informatica?
where to store informatica rejected data?