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
- 10090 Views
- Oracle, I also Faced
- E-Mail Answers
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
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
what type of raid setup would you put your tx logs?
Can any one explain the hierarchies level data warehousing.
ware house management system is used?
Explain what are the steps to build the data warehouse?
What according to you might be the future of data warehousing?
Explain swot analysis?
Explain functional dependency?
How to get the first 100 rows from the flat file into the target?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
Difference between cold fusion 5 and cold fusion mx 6?
What is the 4 + 1 view model as it relates to system modeling?
Where the cache files stored?
Why null values are mapped as 0 in fact tables?
