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 |
How can we run the graph? How can we schedule the graph in unix?
Write a short note on data warehousing & three-Tier Warehouse architecture in detail.
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
What is critical column?
Explain what are the different methods of loading dimension tables?
Hi,Please can u tell me.. What is the difference between a Hyperion Essbase CUBE and a Star Schema? Thanks in advance, Vijay.
What is hybrid slowly changing dimension?
What are various warehousing tools?
Explain what is the metadata extension?
How much data hold in one universe.
What is a general purpose scheduling tool?
Explain the difference between keylokup and joiner?