Answer Posted / kumar
Hi,
Surrogate are System generated sequential Values.
We use these keys to maintain the Historical data in EDW&
to set up relationship between Dimension Table & Fact Table.
It plays a key role in Maintain Historical data in EDW.
We prefer these Keys Even we have the Primary key Columns
in the Tables, since a customer may purchase several times
in a single day irrespective of time & Bill No. are
different.
In this situation we take these keys that give different
No. for several times Purchase in a single day.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the metric store database?
what are the special features in cognos reportnet?
What is the information present in the cognos configuration file?
whats the difference between previous version of cognos and cognos 8 BI?
Can you define cognos powerplay?
What is difference between data mart and data warehouse?
What are the services provided in cognos 8?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
What is the use of powerplay web viewer in cognos?
What is the importance of having monitor service in cognos?
What do you mean by query studio?
Why cognos decision stream is used?
What is looping and how to avoid it in framework manager?
Write some methods to apply securities in framework manager model?
What are the different types of important services used in cognos?
