Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

what is an sid (surrogate key)?

Answers were Sorted based on User's Feedback

what is an sid (surrogate key)?..

Answer / arkchowdary

Surrogate Key----------------- It is a System Generated Key
they are not derived from any Data Sources.

Surrogate Key----------------- It is a Unique Identifier.

Surrogate Key----------------- It is used to identify each
Row of a table uniqely.

Surrogate Key---------------- It also helps to track Slowly
Changing Dimensions.

Surrogate Key---------------- It replaces all Natural Keys.

Is This Answer Correct ?    9 Yes 0 No

what is an sid (surrogate key)?..

Answer / madho

it's a duplicate key for primary key or unique key

when we need to maintain historical data instead of primary
key and unique key we use surrogate key...

Is This Answer Correct ?    5 Yes 2 No

what is an sid (surrogate key)?..

Answer / bhaskar.nagi

It is a System Generated Key. It is act as a Primary Key.

Is This Answer Correct ?    1 Yes 0 No

what is an sid (surrogate key)?..

Answer / zams

Surrogate key is artificial key

Is This Answer Correct ?    2 Yes 5 No

Post New Answer

More Cognos Interview Questions

what is dynamic sort?

1 Answers   Infosys,

Cognos TM1 1. What are the different windows in Turbo Integrator? 2. What is the use of advanced window in Turbo Integrator? 3. What is TM1 Workflow. How do you create a process in that? 4. Where is Portlet used. What are differnt windows in portlet. How can you access TM1 web from portlet? Cognos 8. 1. What is Drill-on? 2.How do you implement row level security in Framework Manager? 3. How do you create tree prompt?

1 Answers   HSBC,

what is view? types of views?

3 Answers   HCL,

suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in the report and this value prompt should contain groups like group1(US,UK,ENG), group2(INDIA,US,UK), group3 (ENG,JAPAN,INDIA)and in the value prompt the values should be group1,group2,group3 how can we do this?

4 Answers  

What is Render Variable? where u can use?

3 Answers  

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?

1 Answers   JPMorgan Chase,

What are the Ways to Import Data into Catalong?

1 Answers   Cognos, IBM,

Why cognos decision stream is used?

0 Answers  

what is loop in frameworkmanager ?

4 Answers   Texas,

how to convert crosstab into list?

4 Answers   TCS,

How we check the errors before running the report?

0 Answers  

can you tell me what are the dimension tables are used in project

0 Answers   GalaxE,