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 is latest version of power center / power mart?
How to eliminate duplicate rows from flat file?
What is a real-time data warehouse?
What is surrogate key? Where we use it?
What are Aggregate tables?
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 meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
What is data analysis? Where it will be used?
What is the function of surrogate key in data warehousing?
What are the steps involved in designing a fact table?
How to get the first 100 rows from the flat file into the target?
What is data type of the surrogate key?
Explain the difference between oltp and olap?
What are the data types present in bo? What happens if we implement view in the designer n report?
Explain the main differences between star and snowflake schema?
What are data validation strategies for data mart validation after loading process?