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 |
Explain vldb?
what are the types of dimension tables
What is the difference between olap and datawarehosue?
Explain er diagram?
What needs to be done while starting the database?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
What is called data cleaning?
What are necessary tasks to install reportnet software?
What is crass reference table?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
What is DTM session?
Explain how to generate iqd file from framework manager?