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
Explain dimensional modelling?
Explain what are the different methods of loading dimension tables?
How to improve session performance in aggregator transformation?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
What are the different ways to represent the loading of dimension tables?
What is surrogate key? Where we use it?
Explain if a flat file cotains 1000 records how can I get first and last records only?
Whether dimension table can have numeric value?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
What is the use of dimensional modeling in data warehousing?
What are universe requirements?
Explain what is partitioning? What are the types of partitioning?
What is a full backup?
Explain er diagram?