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 to a create header dynamically in a crosstab report in cognos 8.1?
What is the difference between a cascading report and drill through the report?
what are slowly changing dimensions? Why we are used scd?
What is main difference mapplets and mapping?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
what is the difference between list report and crosstab report?
what are the errors faced while bursting the reports and how to solve those errors?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
What is the function of cognos dispatcher?
How is cognos model organization works?
How to select multiple values from type-in prompt?
What do you understand by the term 'aggregate cache'?
Explain what is the main advantage of impromptu over cognos reportnet?
Can you define framework manager?
