Interested to Buy Any Domain ? << Click Here >> for more details...
Can any body will explain about sarrogat key?
Thanks in advance...........Prakash
- 7 Answers
- 10994 Views
- I also Faced
- E-Mail Answers
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
Which command using Query Analyzer will give you the version of SQL server and operating system ?
When to use local filter and when to use global filter?
Explain in detail about type 1?
Explain what are the steps to be taken to schedule the report?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
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)?
Can we configure two instances of CMS pointing to two different CMS system databases?
What Is The Difference Between Oltp And Olap?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
What would you consider as your biggest achievement and why?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
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....
how get the grand total in master-detail report?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
