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
Can we test the report other than manual testing?
Can you define dimension?
Write some methods to apply securities in framework manager model?
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
What is the deployment requirements used in cognos?
5. Which type of report you build more, list, crosstab or chart and why?
What is the function of model design accelerator?
how to perform single sign in cognos by using url?
How is cognos model organization works?
i was asked what are the caluclations done by you in your report? plz give reply
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
Define catalog in cognos and write its various types?
Can you explain new content durability?
Can you define a datastore in cognos?
What do you understand by the term 'model durability'?