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


Please Help Members By Posting Answers For Below Questions

What is application.cfm?

772


How do you setup Lo-cockpit?

2811


What are the different types of join operations?

758


What are the stages of datawarehousing?

752


List down some of the real time data-warehousing tools?

747


What are the reasons to use a chameleon method in data warehousing?

797


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?

733


How to design file watch jobs?

741


What is data stream and data adaopter. Is it same are different? Explain?

685


Explain what does level of granularity of a fact table signify?

710


For faster process, what we will do with the universe?

773


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?

771


What are different deliverables according to phases?

3059


What are non-additive facts in detail?

758


Where do we use semi and non additive facts?

773