In a data warehouse model, dimension can be of following types,
☛ Conformed Dimension
☛ Junk Dimension
☛ Degenerated Dimension
☛ Role Playing Dimension
Based on how frequently the data inside a dimension changes, we can further classify dimension as
☛ Unchanging or static dimension (UCD)
☛ Slowly changing dimension (SCD)
☛ Rapidly changing Dimension (RCD)
How can i run the 2 GUI merge files?
How would you find out whether a SQL query is using the indices you expect?
Describe how you would ensure that database object definitions (Tables, Indices, Constraints, Triggers, Users, Logins, Connection Options, and Server Options etc) are consistent and repeatable between multiple database instances (i.e. a test and production copy of a database)?
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
What is the difference between rollup and scan?
Describe the Grant/Revoke DDL facility and how it is implemented?
When using multiple DML statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?
What does dependency analysis mean in Ab Initio?
What is local and formal parameter?
What is BRODCASTING and REPLICATE?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
