Answer Posted / vijay
star schema& snowflake schema.because two schemas are
integrated.
Is This Answer Correct ? | 12 Yes | 4 No |
Post New Answer View All Answers
Explain normalization?
How can you import tables from a database?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
What is a general purpose scheduling tool?
What is operational data store (ods)?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
Why is dimensional normalization not required?
What is core dimension?
Explain what are the possible data marts in retail sales?
What is analytical or analytic mean?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
What needs to be done while starting the database?
What are the different types of data warehousing?
Where the applications and where ware house management system is used?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?