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 application.cfm?
How do you setup Lo-cockpit?
What are the different types of join operations?
What are the stages of datawarehousing?
List down some of the real time data-warehousing tools?
What are the reasons to use a chameleon method in data warehousing?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
How to design file watch jobs?
What is data stream and data adaopter. Is it same are different? Explain?
Explain what does level of granularity of a fact table signify?
For faster process, what we will do with the universe?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
What are different deliverables according to phases?
What are non-additive facts in detail?
Where do we use semi and non additive facts?