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
- 10071 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 universe requirements?
What are the stages that are required in data warehousing?
How do we design a universe?
What is ?Data mining??
What is Analysis Services?
How to pivot row data using informatica?
Business rule implemntation depends on? 1.)ETL requiremnts 2.)ETL performance 3.)business requirements.
What is incremintal loading?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
How can you set the client management?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
Is there any difference in testing database and data ware housing?
Teradata 
