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...

what use of surgate key in project

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we test the report other than manual testing?

2177


Can you define dimension?

1083


Write some methods to apply securities in framework manager model?

1118


How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2573


What is the deployment requirements used in cognos?

1654


5. Which type of report you build more, list, crosstab or chart and why?

2020


What is the function of model design accelerator?

955


how to perform single sign in cognos by using url?

1154


How is cognos model organization works?

1093


i was asked what are the caluclations done by you in your report? plz give reply

2193


3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.

2623


Define catalog in cognos and write its various types?

1183


Can you explain new content durability?

1028


Can you define a datastore in cognos?

1039


What do you understand by the term 'model durability'?

1015