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

Can any body will explain about sarrogat key?
Thanks in advance...........Prakash

Answer Posted / vidhya

Surrogate key: Also known as Sequence id in ORACLE or
Identity column in SQL SERVER (whatever you call to your
convenience).Auto generated keys by the system.

DWH: Used here as a substitute of existing primary key to
encourage duplicates and thereby misleading the rule of
third normal form. Thus maintaining the history of records
which supports SCD(slowly Changing Dimension III)

3NF: Each table should have one primary key

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain is data mart?

998


What is the difference between the public object&schema object?

1049


Can more than 1 metric be applied on an analytic in business objects?

2141


Can we configure two instances of CMS pointing to two different CMS system databases?

2007


How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4707


IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

10366


CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

2140


Can you please send me the migration related issues .

2067


How can you first report in Business Objects by using broadcast agent?

3038


I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3453


Can we create universe with no cache??

2490


How to schedule the report in b.o?

995


Which versions are used in the bo dashboard work?

1034


What is the difference between business requirement document and use case document.

994


What are the steps to do to use alerts in bo?

1373