Diff b/w surrogate Key and Primary Key?
Answers were Sorted based on User's Feedback
Answer / uma
Primary keys are used in OLTP whereas surrogate keys are used in OLAP schemas.PKs hold some business meaning whereas SKs does not hold.PKs contain both numeric as wellas non numeric values whereas SKs contain only simple numeric values.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / krishna
surragate key is a system generated primary key.
| Is This Answer Correct ? | 4 Yes | 1 No |
These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?
Explain what is the difference between microstrategy and cognos reporting tool?
-------------What is Coditional Prompting?
how can you set the image in the report
What are the batches and it’s details?
What is the use of cognos decision stream?
What are the Macros?
What is the difference between the content store and content manager?
what is a prompt value in report studio and variables ?
Explain the difference between powerplay transformer and power play reports?
How can we improve performance in report studio level?
why we r using report studio in webbased only and fm windows based only