Interested to Buy Any Domain ? << Click Here >> for more details...
what use of surgate key in project
- 3 Answers
- 7615 Views
- HCL, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Surgate is a system generator sequence,by using this we can
store the historical data tha means it stores the type 2 data,
it acts as primary key in dimension table
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / fgdfgd
Surgate is a system generate key , using this key we can maintain historical data in DWH .
| Is This Answer Correct ? | 0 Yes | 0 No |
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
Hi Friends, Just want to know, day to day is increasing or decreasing Cognos Usage in the Market? New Reporting tools to driving Reporting Market Spotfire, Tableau,Qlick View, some other New Tools. Which Reporting tool can generate Lot of Opportinities in the Market? Please Reply to this, My Advanced Thank to you. Thank You Kumar
how can you set the image in the report
How do you schedule process automatically in cognos.I.e we have 50 reports and 100 users that will schedule daily, weekly, and monthly basis? Pls, give the answers the query early on.
what is the role of cognos comsultant?what actually it means?pls reply
how to test reports in cognos?
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..
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
-----------What is member Description?
Is there any comparison available for Cognos Reportnet Vs Crystal reports?
what is the diffence between render variable & style variable with egs? Plz reply ASAP
Teradata 
