Why joiner transformation does not allow the aggregator
transformation and expression transformation to join
Answers were Sorted based on User's Feedback
Answer / abhishek
We can join the aggr and epx in joiner even if they are from same source. We Need to check the sorted input property in joiner.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / 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 |
What is the extension of file to save template?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
What are the different types of scd's used in data warehousing?
How to create context?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
Compare cold fusion with other programming languages?
Explain why denormalization is promoted in universe designing?
Explain what are the methodologies of data warehousing?
What are modeling tools available in the market?
What is a linked cube?
Hierarchy of DWH?
2 Answers Accenture, EDS, IBM, iFlex, TCS,
What is MDX?