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 use of surgate key in project

Question Posted / pradeep

Answers were Sorted based on User's Feedback



what use of surgate key in project..

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

what use of surgate key in project..

Answer / sindhuchowdary5

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

what use of surgate key in project..

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

Post New Answer

More Cognos Interview Questions

After generating value prompt,when we run the report... then we will get the prompt in the output.. Along with that prompt we will get diff types of symbols highlited......How can we hide those symbols?

1 Answers   IBM,

How much time it will take to develop a report in real time? It depends upon the complexity of the report, so tell me the approximate time period for a simple list, cascading, master-detail, drill-through,..…etc?

3 Answers  

-----------What is member Description?

2 Answers  

What is the use of cognos decision stream?

0 Answers  

what is log in cognos?

0 Answers   IBM,

Can we install cognos 8 on windwos xp sp3.......(and i like to use data base as sql server 2000.....is it preferable?)......... pls let meknow... thaks in advance...

1 Answers  

10. In Report studio ,how to get the top 20 employees in using list report Row number – if only list  Rank  Running-count

1 Answers   Data Semantics,

Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

0 Answers  

What is the difference between set functions and filter function in dimensional data?

0 Answers  

What is defined as data mining?

0 Answers  

How do we run stored procedure?

1 Answers  

What is Metrics designer?

0 Answers  

For more Cognos Interview Questions Click Here
Categories