Interested to Buy Any Domain ? << Click Here >> for more details...
what is the different between primarykey and surrogated
key.. why we are going for surrogatekey...
- 1 Answers
- 6130 Views
- I also Faced
- E-Mail Answers
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 |
What is cognos reporting tool?
Why Star Schema is de-normalized? Please explain in detail probably with some examples.
Diff b/w Crossproduct and Outerjoin?
What is Tool Tip? and how to create in report studio?
Can anyone explain the procedure for configuring cognos8 with oracle as Content Manager/Content Store? I know the configuration of cognos8 with SQL SERVER (Like how to create CM database in oracle and applying securities to access that Database from cognos8 (Cognos Configuration)
actually my qus is i used some tables in my model,i published that to connection i use that one.at the same way my team member added some new tables and again he published how can i get my model in connection pls pls explain me..........
What is the difference between a cascading report and drill through report?
hi, I want to create this report... List View--- -(Drop down list) Order Date From: \/ To: Customer Employee Order customer ------------------------------------------------------------ ------------------------------------------------------------ ------ customer c-name c-address c-phone c- city.................... ------------------------------------------------------------ ------------------------------------------------------------ ----- c-id c-type . . . ------------------------------------------------------------ ------------------------------------------------------------ ---- Employee .............same like one list Order.....................same like one list These are all in one page....i want u show... condtions *when i select in view type ex:employee and date as 10-05- 2007 to 10-05-2010 I need to go the employee list table and display the items .. And Iam trying in value prompt for creating of (cust,emp,ord)in a single value prompt,that will not created... and how to create 3-list and connection for those in value prompt.. Pls any one knows explain me (by step by step) of creating that report? Thanks Vannur
Explain the different stages in creating a report in cognos report net?
Can you explain model durability?
It is possible to give 2 query items has measures in cross tab?for ex:row as products,column as year and measure as revenue,sales year....like that.It is possible r not ?If it's possible pls tel me the process....
It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha
Teradata 
