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 |
Data WareHousing course in noida
what are the others of "bad files" and "discard files" when using sql*loader?
Explain what are the different types of data warehousing?
what is an use case?
0 Answers InfoAxon Technologies,
Explain what are the various reporting tools in the market?
Explain functional dependency?
What is dimension modeling?
Code the tables statement for a single-level (most common) frequency?
What is surrogate key? Where we use it? Explain with examples.
Explain what is analytical or analytic mean?
What is drill-through?
List any five applications of data warehouse.