If we are using an aggregator but forget to mention the
group by port .what will be the output??
Answer Posted / kt
If we miss to enable any of the port as GROUP BY, the
aggregator will write the lat row of the table to the next
trnasformation.
| Is This Answer Correct ? | 50 Yes | 1 No |
Post New Answer View All Answers
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How might you approve all mappings in the archive all the while?
What are the different clients of powercenter?
Explain what are the different types of transformation available in informatica.
What can we do to improve the performance of informatica aggregator transformation?
what is index?how it can work in informatica
How do you load unique records into one target table and duplicate records into a different target table?
What is transformation?
How do you change a non-reusable transformation to reusable transformation?
Enlist the various types of transformations.
How to update or delete the rows in a target, which do not have key fields?
Explain the difference between a data warehouse and a data mart?
Explain what is informatica metadata and where is it stored?
How do you promote a non-reusable transformation to reusable transformation?
Differentiate between router and filter transformation?