⟩ Explain What are conformed dimensions?
Conformed dimensions mean the exact same thing with every possible fact table to which they are joined
Ex:Date Dimensions is connected all facts like Sales facts,Inventory facts..etc
Conformed dimensions mean the exact same thing with every possible fact table to which they are joined
Ex:Date Dimensions is connected all facts like Sales facts,Inventory facts..etc
Explain What are the basic needs to join two sources in a source qualifier?
What is the use of incremental aggregation? Explain me in brief with an example?
What are the joiner caches?
Explain What is power center repository?
Explain What is metadata reporter?
What are the unsupported repository objects for a mapplet?
How can we transform row to column?
What is a time dimension? give an example?
Explain Why dimenstion tables are denormalized in nature?
How to eliminate duplicate rows from flat file?