How can we load the time dimension?
No Answer is Posted For this Question
Be the First to Post Answer
What is a fact table?
Explain difference between snow flake and star schema.
What is the main difference between star and snowflake star schema? Which one is better and why?
What are Non-additive facts?
Explain what are the advantages of query studio compared to report studio?
What is Cognos script editor?
I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK AND DATE VALIDITAION LOAD TO TARGET TABLE
If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
How to create prompts in report net?
What according to you might be the future of data warehousing?