Why joiner transformation does not allow the aggregator
transformation and expression transformation to join
- 2 Answers
- 9503 Views
- I also Faced
- E-Mail Answers
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 |
What is META DATA information in Data warehousing projects?
What is "method/1"?
What is normalization, first normal form, second normal form, third normal form?
How much data hold in one universe.
What is factless fact schema?
Can we have more than one time dimensions in a Schema(Star or Snowflake)
What is load manager?
What is data analysis? Where it will be used?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
Why should we use data ware housing and how can you extract data for analysis with example?
What is difference between e-r modeling and dimensional modeling?
Explain what is the advantages data mining over traditional approaches?
Teradata 
