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 |
Define query items?
Hi is any one having link to download books on datawarehouse tool kit by ralph kimball or any other authors books.
Can any one help me about cubes in cognos.How to create the cubes and how to migrate from development to QA and also what is the procedure to refresh teh cubes.
Difference between Express authoring mode and Professional authoring mode?
What are all the components of Report Studio?
Can you define cognos decision stream?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
What is Merging, Segments and porting in Framwork Manager?
How to Create users in cognos Access Manager from 1) front end 2) back end
how to create average on totals of different departments employees salary...? consider we have 3 dept and in each dept 10-15 workers i need to get the totals separately for each dept and average of there totals..help me pls
Why are meta service important then other services?
write a query to display to 10 max record from the employee table?