suppose data are coming from different locations and those
data will not change . is there any need to use surrogate key ?
Answer Posted / 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 |
Post New Answer View All Answers
Fact table is in normalized or de-normalized form?
How many project sources we can create in metadata?
What are fact, dimension, and measure?
Why should we use data ware housing and how can you extract data for analysis with example?
Explain where do we use semi and non additive facts?
Why fact table is in a normal form?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
How can you set the client management?
Tell me what is full load & incremental or refresh load?
Explain what are the tasks that loadmanger process will do?
What are the advantages and disadvantages of reporting directly against the database?
What is the difference between datawarehouse and bi?
What is data stream and data adaopter?
What is latest version of power center / power mart?
Compare cold fusion with other programming languages?