⟩ Is there any possibility to generate alphanumeric surrogate key?
It is not possible to generate alphanumeric surrogate key
in datastage.
It is not possible to generate alphanumeric surrogate key
in datastage.
What is data cleaning? How can we do that?
Can any one explain the Hierarchies level Data warehousing.
Can any one explain about Core Dimension, Balanced Dimension, and Dirty Dimension?
How much data hold in one universe.
What is Core Dimension?
After we create a SCD table, can we use that particular Dimension as a dimension table for Star Schema?
What is the difference between Snowflake and Star Schema? What are situations where Snowflake Schema is better than Star Schema when the opposite is true?
What is the difference between star and snowflake schemas?
Can a dimension table contain numeric values?
How many clustered indexes can u create for a table in DWH? In case of truncate and delete command what happens to table, which has unique id.