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

what is model and say about process how to create model and how to test model?

0 Answers   IBM,


Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I have been asked this question twice..i think this feature is available in cognos 10 version..not very sure....Could anybody highlight?

7 Answers   Cognizant, Cognos,


what is the difference between Cognos EP7 series and Congos8?

2 Answers   Hexaware,


What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?

0 Answers   IBM,


What are the advantages of using cognos sql?

0 Answers  






I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

0 Answers   CTS,


what is an associated query?

2 Answers  


i wanna some client names and project names in cognos? plz send cognos resumes(3+) exp plz plz plz help me??

1 Answers   TCS,


Hi, I got a requirement wehre in in a drill through report , in parent report i have a column of numbers on which i have to apply drill through to child report.The condition is in that column if the number ia not zero the drill through link should appear (i.e., 1 to 9) if its 0 or negative number link should not appear. How ? Help would be appreciated

1 Answers   IBM,


---------------How to identify First Record and Last Record?

2 Answers  


what is the difference between java script and html in cognos?

1 Answers   IBM,


what is a Galaxy Schema?

2 Answers   IBM,


Categories