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
What is partitioning? What are the types of partitioning?
Explain what are the vaious etl tools in the market?
How can we load the time dimension?
How to reduce warnings?
Explain why dimenstion tables are denormalized in nature?
Explain what are the different types of join operations?
What is a real-time data warehouse?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Explain what is the limit to the number of sources and targets you can have in a mapping?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
How to calculate fact table granularity?
What are aggregate tables and aggregate fact tables?
Explain what is metadata reporter?
What is called data cleaning?
Explain how many ways you create ports?