Answer Posted / santhosh kumar n
a dimension which can be shared by multople fact tables is
known as conformed dimension. this concept is from galaxy
schema.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is an use case?
Explain what are the various methods of getting incremental records or delta records from the source systems?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
How do you create surrogate key using ab initio?
What is a view as it relates to system modeling?
Explain what are the tasks that loadmanger process will do?
What is execution plan?
What are target types on the server?
Explain what is the metadata extension?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
How can you set the session management?
Explain what is partitioning? What are the types of partitioning?
What are necessary tasks to install reportnet software?
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?
What are the types of dimensional modeling?
