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

How to create a dynamic column name in Cognos?

6 Answers   Aditya Birla, Polaris,


How can we convert imr report into Impromptu web report?

3 Answers  


Why we take so long time to display date prompt before displaying a report? How can we reduce the time?

2 Answers  


Give me some examples for Lifecycle reporting,i mean which lifecycle we will use for reporting

2 Answers   IBM, TCS,


What are the different types of important services used in cognos?

0 Answers  






What actually a project contains?

0 Answers  


2. What functional area you worked on.

0 Answers   IBM,


What are the differences between main Cognos 8.2 and 8.3 ?

2 Answers   IBM,


Can you define a catalog and types of catalogs in cognos?

0 Answers  


What is the difference between low affinity and high affinity connections?

0 Answers  


For example I developed some reports on employee package now I have to develop same reports to another package.How can I change reports to another package?

5 Answers   TCS,


why we r using report studio in webbased only and fm windows based only

1 Answers  


Categories