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 are the stages that are required in data warehousing?
explain about balanced dimension,
What is the limit to the number of sources and targets you can have in a mapping?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
Explain what are the possible data marts in retail sales?
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.
In document how to create metrics?
Explain difference between e-r modeling and dimentional modeling?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Why is chameleon method used in data warehouse?
Explain vldb?
Explain the definition of normalized and denormalized view?
What are the different models used in cluster analysis?
can anybody mail me the FAQS for hyperion essbase amd planning