suppose data are coming from different locations and those
data will not change . is there any need to use surrogate key ?
- 3 Answers
- 8763 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 |
Name a few sectors which use data warehousing?
Which kind of index is preferred in DWH?
can anybody mail me the FAQS for hyperion essbase amd planning
if source contain 10records how you identify header and footer
What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh
how can one connect two fact tables ? is it possible ? how?
Explain what are the various file formats involved in reportnet?
What is data stream and data adaopter?
I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK AND DATE VALIDITAION LOAD TO TARGET TABLE
List down some of the real time data-warehousing tools?
How can Oracle Materialized Views be used to speed up data warehouse queries?
Explain what is the difference between a primary and secondary actor in use case modeling?
Teradata 
