How can we find out cardinality between two tables?

Answers were Sorted based on User's Feedback



How can we find out cardinality between two tables?..

Answer / sharath.dwh

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

How can we find out cardinality between two tables?..

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

How can we find out cardinality between two tables?..

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

Post New Answer

More Cognos Interview Questions

We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

0 Answers  


Can u please describe the different types of traps with eg. Thanks

2 Answers  


How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..

0 Answers  


1.tyes of security in cognos?.how to use rank function? 2.what is content store? 3.what is content manager? 4.how 2 use rank function?

3 Answers  


Main Differnce between Cognos7 and Cognos8

1 Answers   IBM,


What are different events in Report studio?

0 Answers   Wipro,


Can we use 2 packages in report studio at a time is there any alternative for this Thanks Nithin

7 Answers   IBM,


how you provide security to reports? How you provide security to packages ?

0 Answers   IBM,


can any body clesrly explain about types of query subjects.that is data source query subject,model query subject,stored procedure query subjects?

1 Answers  


Can you explain dynamic query mode?

0 Answers  


can you apply grouping on crosstab?

1 Answers   CTS,


Can you define a datastore in cognos?

0 Answers  


Categories