suppose data are coming from different locations and those
data will not change . is there any need to use surrogate key ?
Answer Posted / deepthi
yes there is the use of surrogate key
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the steps of implementing data warehousing?
How to get the first 100 rows from the flat file into the target?
Explain what is a cube in data warehousing concept?
What we will do with the universe for faster process?
What is is a star schema?
what are different storage options supported by oracle ?
How do you create surrogate key using ab initio?
What is a linked cube?
For faster process, what we will do with the universe?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is the difference between a primary and secondary actor in use case modeling?
What should I have in mind when building olap solution from scratch?
How can we schedule the graph in unix?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Explain if a flat file cotains 1000 records how can I get first and last records only?