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
- 10174 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 |
Explain the definition of normalized and denormalized view and what are the differences between them?
What is the difference between a primary and secondary actor in use case modeling?
Define data warehouse?
How to generate iqd file from framework manager?
what are different types of partitioning in oracle ?
Write a short note on data warehousing & three-Tier Warehouse architecture in detail.
How can you define a transformation? What are different types of transformations in Informatica?
Can you pass sql queries in filter transformation?
Can you brief about the Data warehouse project you worked on?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
Explain Process flow in data warehouse??
What is the definition of cube in datawarehousing?
Teradata 
