Interested to Buy Any Domain ? << Click Here >> for more details...
suppose data are coming from different locations and those
data will not change . is there any need to use surrogate key ?
- 3 Answers
- 10230 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / suri
Yes, We should use the surrogate key, here we are geeting
data from different locations means every one have one
primary key, while transforming the data into target that
time morethan two key not in use so if you use surrogate
key it will identified the duplicate fields in dimensional
table.
| Is This Answer Correct ? | 6 Yes | 0 No |
What are the differences between datamart vs. Reporting cube?
What is subject area?
DWH architecture?
Explain the difference between view and materialized view?
2.What is staging area ?
4 Answers HCL, IBM, iFlex, TCS,
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.
Explain what is a cube in data warehousing concept?
Explain the data type of the surrogate key?
Describe the differences between a data warehouse and data mart.
What is the difference between view filter and report filter?
Why denormalization is promoted in universe designing?
What is MDX?
Teradata 
