Why joiner transformation does not allow the aggregator
transformation and expression transformation to join
Answer Posted / john
The mapping designer does not allow multiple active transformations or one active and one passive transformation to get connected to same downstream transformation. It would throw an error saying Informatica cannot concatenate the rows passed. However sequence generator is an exception. The mapping designer allows two passive trasnformations to connect to same downstream as passive transformation does not change the number of rows.
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Explain what are the different methods of loading dimension tables?
What are the different types of data warehouses?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Who needs data warehousing?
Explain what are the steps to build the data warehouse?
What is a functional dependency f said to be minimal?
What are the different types of segments?
What is surrogate key? Explain with examples.
What is a staging area? Do we need it? What is the purpose of a staging area?
Explain difference between data ware house & data mart?
What is hybrid slowly changing dimension?
How can you set the client management?
What is the purpose of Dataware Control?
What is data analytics in simple terms?