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
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
What are aggregate transformation?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
How many types of facts and what are they?
Explain what are the different types of join operations?
Explain what is the difference between a primary and secondary actor in use case modeling?
The same tier?
Explain what is type 2 version dimension?
What is surrogate key? Where we use it? Explain with examples.
what are the all possible features supported modify stage?
What are the stages that are required in data warehousing?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
What are the steps of implementing data warehousing?
Explain what are components of report studio?
After the complete generation of a report who will test the report and who will analyze it?