Interested to Buy Any Domain ? << Click Here >> for more details...
Why joiner transformation does not allow the aggregator
transformation and expression transformation to join
- 2 Answers
- 10205 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Why is dimensional normalization not required?
Explain what are components of report studio?
Explain what is the data type of the surrogate key?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
What is the difference between star and snowflake schemas?
What is the difference between snowflake and star schema?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
What is metadata in context of a datawarehouse and how it is important?
What is data analysis?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
Compare and contrast aggregates & indexes
How to eliminate duplicate rows from flat file?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Explain what does level of granularity of a fact table signify?
The same tier?
