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

Can any one help me by ansewring this question:-What are the errors encountered while executing your reports?(Depending on your own experiences) Thanks in advance.

3 Answers   iGate,


What are the two types of framework manager?

0 Answers  


Due Date (Highlight Issues in Blue where Due Dates are less than Todays Date),I have only Due Date column then how to over come the problem.How to find out which Due Date are less than Today Date...Kindly provide the detail steps to my mail ID-->asimcognos10@gmail.com

2 Answers   IBM,


Explain the difference between native sql and cognos sql?

0 Answers  


After generating value prompt,when we run the report... then we will get the prompt in the output.. Along with that prompt we will get diff types of symbols highlited......How can we hide those symbols?

1 Answers   IBM,






how to create measures and dimensions?

0 Answers   IBM,


how to create relationship between emp and salgrade tables in frameworkmanager?

1 Answers   TCS,


In framework Manager, what is a stitch query and is it good or bad?

2 Answers   Polaris,


HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

0 Answers  


can we create a chart without measure

3 Answers  


what is the main advantage of impromptu over cognos reportnet?

0 Answers  


What are the roles defined by cognos platform?

0 Answers  


Categories