Can any body will explain about sarrogat key?
Thanks in advance...........Prakash
- 7 Answers
- 8717 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
What is a fantrap in business objects?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
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?
how to create reports on screech?
Explain how to schedule the report in b.o?
Did you face any problems while creating reports? Name? Solutions?
Explain the difference between union and group?
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!!!
What are the join problems comes appart from loop,chasm & fan Traps
is it possible to export the webi reports to crystal reports?with out using businessview?
Is there any other repository domains rather than universe, security, document?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
Explain which versions are used in the bo dashboard work?
