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
Explain what are the basic needs to join two sources in a source qualifier?
What is dimension modeling?
What is the difference between power center and power mart?
Explain what is a three tier data warehouse?
Whether dimension table can have numeric value?
What is the use of dimensional modeling in data warehousing?
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
What is factless fact tables?
Explain the main difference between inmon and kimball philosophies of data warehousing?
What is analytical or analytic mean?
What are aggregate tables and aggregate fact tables?
Which component has onread method and what it is used for?
what are the others of "bad files" and "discard files" when using sql*loader?
Explain what are conformed dimensions?
I need to set predefined condition. How I do this?