Answer Posted / ram
Surrogate keys are keys that are maintained within the data
warehouse instead of keys taken from source data systems.
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What are loops in Datawarehousing?
Fact table is in normalized or de-normalized form?
Code the tables statement for a single-level (most common) frequency?
How to generate iqd file from framework manager?
Explain the difference between filter and conditin?
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?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
Compare cold fusion with other programming languages?
What is surrogate key? Where we use it explain with example?
What is the differences between star and snowflake schemas?
What are the tools available for etl?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
Explain what is difference between query studio and report studio?
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.
What are situations where snow flake schema is better than star schema to use and when the opposite is true?