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
What is the dense rank?
can anybody tell me about complicated object you have created
Explain what are the steps to do to use alerts in bo?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
how to create reports on screech?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
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....
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
what are the day to day activities of BO administrator ?
Explain what task is 98% of the required work of a business analyst?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
How to create Index to the table in the universe designer and how it improves the Query performence
Explain when to use local filter and when to use global filter?
What is top business?