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 conformed fact?
What are the types of dimensional modeling?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Why denormalization is promoted in universe designing?
How to drill through from a powerplay cube to reportnet?
What is the difference between drill through and masterdetail reports?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
What are data validation strategies for data mart validation after loading process?
What is cost benefit analysis (cba)?
What is a full backup?
explain about dirty dimension?
Explain the versions of reportnet?
What are the different types of join operations?
What are data modeling and data mining? Where it will be used?
Explain what is analytical or analytic mean?