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 model and say about process how to create model and how to test model?
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?
what is the difference between Cognos EP7 series and Congos8?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
What are the advantages of using cognos sql?
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
what is an associated query?
i wanna some client names and project names in cognos? plz send cognos resumes(3+) exp plz plz plz help me??
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
---------------How to identify First Record and Last Record?
what is the difference between java script and html in cognos?
what is a Galaxy Schema?