How can we find out cardinality between two tables?
Answers were Sorted based on User's Feedback
IN FRAMEWORKMANAGER GO TO WE HAVE 3 TABS
1)EXPLORER TAB
2)DIAGRAM MAP TAB
3)DIMENSION TAB
WE CAN CHECK CARDINALITY BETWEEN TWO TABLES IN DIAGRAM TAB.
SHARATH
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / balanandam
basing on the following
1. primary key and foreign key relation ship between the tables
2. columns from both tables having same behavior in terms of length and data type
3. basing on common unique index columns
generally 1 & 3 cases are using more
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / anusha
Hi,
In Framework Manager, what the developers give between two
tables as cardinality will be reflected. But before builing
the relationship, the developer has to determine it based
on the semantics of the data. It can be one to one (1..1)
or one to many(1..n) or many to many(n..n)
| Is This Answer Correct ? | 0 Yes | 2 No |
What is difference between primary key and unique key constraints?
hi cognos Experts what are the enhancements in cognos 10 than cognos 8.4?Pls Ans Me........
what is the role of cognos comsultant?what actually it means?pls reply
can we put more measure on cross tab? If so how many? How this affect the aggregation?
What do you mean by drill through report?
what is Cognos Visualizer?
can any body clesrly explain about types of query subjects.that is data source query subject,model query subject,stored procedure query subjects?
What is the difference between a cascading report and drill through report?
what are the components having in the report studio using interface eg:insertable objects pan,properties pan
How can you schedule a report based on different time zone ?(ex: local time should be same as 10 am . Japan should get the report at 10 am. USA should get the report at 10 am).Is that possible?
How is cognos model organization works?
A report is scheduled at 2am in the night... and the report contains 4 value prompts how it is going to be executed without selecting the values....if executed who is going to select the values from the value prompt