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

what are the tables used in health care domain project and columns used in report?

4512


Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1955


what is xcelsius architecture?

4580


Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

1061


Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1883


What is object stores?

984


Explain when we use aggregate awareness function in designer?

1023


Explain what task is 98% of the required work of a business analyst?

1103


How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

2427


Differences between business objects and web intelligence reports?

1223


how many reports have u created ? explain a few.

2099


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

1394


Can you please send me the migration related issues .

2073


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

1266


What is the functional & architectural differences between business objects and web intelligence reports?

2412