how many types of keys are there i.e primary key and foreign
key etc..?
Answers were Sorted based on User's Feedback
Answer / palzkumar
Piggynet is very close...
Actually there are 3 types of referential integrity constraints (i guess you referring this as keys) are available in DB...
1. Primary Key
2. Unique Key
3. Foreign Key
Composite Primary Key is same as PK, but its applied on combination of 2 or more columns.
-Palz
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / piggynet
Primary key
Foreign key
Composite key
Surrogate key
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / sowmya
keys r of 4 types. 1.super key , 2.candidate key 3 primary
key 4.foreign key
| Is This Answer Correct ? | 3 Yes | 3 No |
Can you define cognos impromptu?
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
Can any one expalain the procedure for How to create a Mastr Detail Report in Cognos 8.3 ver?
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
which table we load first in DW. dimension or fact? why?
4 Answers IBM, JPMorgan Chase,
I need your kind support. I have more than 6yrs of exp in s/w industry. I have worked on some DW technologies which are out dated. For almost 1 year I was on bench.During this bench period I learnt cognos on my own using online docs. Hence I am alligned to a project few months ago to work on cognos. Unfortunately after joining this project I did not get opportunity to work on cognos. I am working on different things apart from cognos. I should get job in another company. Otherwise I am gone. I am confident enough to get job on Cognos in another company. Please let me know is it possible to work on Cognos at lead position (as my current position is at lead level) without having real time experience. Your response is highly appreciated and I will be grateful to you. Thanks in advance Ganesh
how do you test reports in reportnet? what do you record in unit testing documents? pls give answer in detail......
write a query to display to 10 max record from the employee table?
what is surrogate key give example?
------------ Diff b/w MemberCaption and MemberDescription?
Define olap designer?
What is the difference between a cascading report and drill through report?