what is surrogate key give example?
Answers were Sorted based on User's Feedback
Answer / pavan kumar
A Surrogate Key is a system generated sequence numbers to
be used as primary keys.
A Surrogate keys are used in maintaining the full history
in scd type2.
A Surrogate key is also known as Synthetic Key or
Artificial Key or Dimensional Key.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / gopal
Surrogate key is system generated unique key to maintain the duplicates values.
Is This Answer Correct ? | 1 Yes | 0 No |
How to create a cube in Transformer? What is the process? Please mention process thank u
what are the filters in framework manager and report studio?
What is looping and how to avoid it in framework manager?
What are the other methods working as deployment functionality?
What is the difference between the content store and content manager?
What is the difference between drill through, drill across?
Can you define a catalog and types of catalogs in cognos?
what is model and say about process how to create model and how to test model?
What is drill down and slicing and dicing whats the difference between them?
What are the best practices while building a Cognos Framework Manager Package ? As in, what calculations would you not like to be handled in FM and rather get it directly from Database.
i want to create a crosstab report where product will be on rows year on column and revenue on measure. based on the users selection in value prompt, if user select the August 15, crosstab year column should display values for aug 15, aug 14, aug 13 and aug 12 i.e for last for years but same month. how could we achieve this?
What are the main services provided by application tier?