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 to add a number to a macro variable?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
Can you state some of the innovations throughout history?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
What are the approaches used by optimizer during execution plan?
Explain dimensional modelling?
Explain what are non-additive facts?
What is multi-dimensional analysis?
What is a general purpose scheduling tool?
What is VLDB?
What is confirmed dimension?