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 |
Give some difference between oltp and olap.
What is the differences between star and snowflake schemas?
What is Star Schema?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
What is data analysis? Where it will be used?
For faster process, what we will do with the universe?
What are the steps of implementing data warehousing?
How to performance tune reports?
Difference between DSS & OLTP?
Explain about Control M JObs detaily?How to execute this.
2 Answers Scope International,
What is vdl (view definition language) explain?
Is there any difference in testing database and data ware housing?