what is surrogate key give example?

Question Posted / subbu.paleru123

2 Answers
6283 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is surrogate key give example?..

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

what is surrogate key give example?..

Answer / gopal

Surrogate key is system generated unique key to maintain the duplicates values.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More Cognos Interview Questions

What is the difference between a data mart and a data warehouse?

0 Answers

Write a SQL query which should fetch the 5th maximum salary of an employee from the table?

14 Answers HCL,

can you apply grouping on crosstab?

1 Answers CTS,

What do you understand by the term 'aggregate cache'?

0 Answers

Is it possible to apply access manager user rights in impromptu?

1 Answers

what are slowly changing dimensions? Why we are used scd?

0 Answers IBM,

Can you define framework manager?

0 Answers

what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

0 Answers

Can you explain new content durability?

0 Answers

How many types of models are present in cognos.?

4 Answers

What is Correlated sub-query? Please explain

1 Answers Target,

Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.

0 Answers CTS,

For more Cognos Interview Questions Click Here