Interested to Buy Any Domain ? << Click Here >> for more details...
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
How can create users and permissions in cognos?
7. What is performance tuning?
What is a Transformer?
Can you define fan trap?
Why cognos decision stream is used?
What is difference between content store and content manager?
what is the difference between querystudio in reportnet and cognos8
What is the enterprise class platform architecture of cognos 8?
What is drill down and slicing and dicing whats the difference between them?
faq's on cognos
-------------What is Coditional Prompting?
what are the errors faced while bursting the reports and how to solve those errors?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
What are query items?
How can you link a query to a data container manually in Report Studio?
