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
Define Data Warehousing?
What is hybrid slowly changing dimension?
How to pivot row data using informatica?
How to pivot data using informatica when you have variable amount of pivot rows?
I have two universes created by two difference database can we join them in designer & report level? How
Explain what are the methodologies of data warehousing?
Explain the different types of data warehousing?
What are session timeout and application timeout? Where we have to do this process?
Explain what is the metadata extension?
What is cfapplication tag?
Can decision tree be implemented using SQL?
Difference between cold fusion 5 and cold fusion mx 6?
What a static and local variable?
How to reduce warnings?
What is load manager?