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


Please Help Members By Posting Answers For Below Questions

What is drilling across?

632


How to generate the cubes in framework manager?

625


What is Discrete and Continuous data in Data mining world?

2204


How to join 3 database like flat file, oracle, db2 in informatrica?

719


What are the different types of data warehousing?

606






What is bi?

665


Explain meta data?

635


Explain which are the olap tools available that are supported by oracle?

627


Explain about core dimension, balanced dimension, and dirty dimension?

638


What are aggregate transformation?

679


What is the difference between power center and power mart?

647


Explain why fact table is in normal form?

611


Is union transormation is active transformation?

661


Explain dimensional modelling?

607


What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?

683