suppose data are coming from different locations and those
data will not change . is there any need to use surrogate key ?
Answer Posted / shaj
Yes, we need to add the surrogate key in table.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is drilling across?
How to generate the cubes in framework manager?
What is Discrete and Continuous data in Data mining world?
How to join 3 database like flat file, oracle, db2 in informatrica?
What are the different types of data warehousing?
What is bi?
Explain meta data?
Explain which are the olap tools available that are supported by oracle?
Explain about core dimension, balanced dimension, and dirty dimension?
What are aggregate transformation?
What is the difference between power center and power mart?
Explain why fact table is in normal form?
Is union transormation is active transformation?
Explain dimensional modelling?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?