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 |
Is it possible to join multiple Databases in a Catalog?
How you create IQD In ReportNet FrameWork?
1)How can we do the Union in Report Studio? 2)What is the meaning of Aggregation and Rollup Aggregation? 3)How can we hide the columns in Report Studio and How can we view the hiding Objects? 4)Can we provide joins in Report Studio and in which situation we can go for outer join? 5)If we take a Date Prompt and run it once it will show default data,how can we change it exact 1 month back data?
----------------Describe DWH Architecture?
how will optimiz the performance of sql in FM ?
what is the difference between rollup aggregation and aggregation ?
What is Cardinality
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
Explain about scorecarding?
how u migrate the reports from impromptu to reportnet???
which difficult you faced in your project?
Hi Buddies... i want to appear for cognos BI-Author certification. can anyone of you send me cognos latest dump. please help me.. cognoslalitha@gmail.com