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
How to improve session performance in aggregator transformation?
What is the function of surrogate key in data warehousing?
Explain what are slowly changing dimensions?
Explain what is the limit to the number of sources and targets you can have in a mapping?
What is a staging area? Do we need it? What is the purpose of a staging area?
What is the difference between view materialized view and view?
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
Explain which are the olap tools available that are supported by oracle?
Explain what are the various file formats involved in reportnet?
What are algorithms provided by Microsoft in SQL Server?
What is partitioning? What are the types of partitioning?
How can we run the graph? What is the procedure for that?
explain about balanced dimension,
How can you clear the cache?
What is the purpose of cluster analysis in data warehousing?