Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

what is an sid (surrogate key)?

Question Posted / sekhar

Answers were Sorted based on User's Feedback



what is an sid (surrogate key)?..

Answer / m m naidu

surrogate key: It has system generated artificial key
values, which allows to maintain historical records in the
data warehouse more effectively.

Is This Answer Correct ?    2 Yes 1 No

what is an sid (surrogate key)?..

Answer / rajdeep chatterjee

Surrogate key is an artificial key which is a system
generated one. It can be created from Oracle using
sequence, can also be created using ETL tools. It is the
unique key is dimension tables. The purpose of using
Surrogate key is to reduce the dependency from underlying
database.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

what is materialised view? why we use it in data warehousing?

5 Answers   HCL,

What is an olap designer?

0 Answers  

What is the difference between drill through, drill across?

0 Answers  

How to move reports one server to another server?

2 Answers   Wipro,

What is value prompt limitations while creating report? What is select and search prompt?

1 Answers  

-------------------What is Deployment?

2 Answers   IBM,

What are the types of hierarchies?

0 Answers  

what is the difference between list report and crosstab report?

0 Answers   IBM,

how can you restrict the number of values available for a prompt? i tried this by using static choices property, but i dint get result... so pls explain in detail steps....

3 Answers  

What is a scope? can you tell me one example for scope?

1 Answers   CTS, IBM, TCS,

What are the Ways to Import Data into Catalong?

1 Answers   Cognos, IBM,

What are the types of folder present in cognos?

0 Answers  

For more Cognos Interview Questions Click Here
Categories