what is the different between primarykey and surrogated
key.. why we are going for surrogatekey...
Answer / g.v
Primary key as all of u know this is a unique key,surrogate
key is a non -intelligent key which is used to replace a
composite key
we are going for surrogate key bcz suppose a person is
living in one city and then moved to other and the person
id is a primarykey.we need to update the location then we
need to add the updated record but the primary key wont
accept to add the record again for this purpose we will go
for surrogate key
Is This Answer Correct ? | 9 Yes | 0 No |
can any one explain about blue prints&performance tuning in cognos?
Can you define a query subject?
Explain the workflow of your current project from end to end?what is the steps?
2 Answers Accenture, Cap Gemini, Cognizant, HCL, IBM, Infosys, Nokia,
what is the use of layout component reference
tell me two or three issues from client side and how to solve those issues?
what is cube size?
What is the difference between a cascading report and drill through report?
WHAT STEPS SHOULD BE TAKEN BY A REPORT DEVELOPER TO INTERACT WITH THE CLIENT SERVER?
How to create users and permissions in cognos?
I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year),by using both the tables we hava to create list columns like(country,month,net revenue)when i run the report if my retrevenue'0'this plasa i want to display'NULL'
How to connect three fact tables?
11 Answers L&T, TCS,
what is the difference between count and running-count functions?