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 |
What is a data profile?
What is dimensional modelling?
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 meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
State any 5 of Cods guidelines of an OLAP system, brief description each?
How can you set the client management?
How can you set the session management?
What are fact, dimension, and measure?
What is a hash cluster?
What is the difference between view materialized view and view?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
3 Answers Extech, Principal Finance,