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 |
how to find the rank in report studio? i need steps for this question.
What is defined as catalog and types of catalogs in Cognos?
what is render variable
5 Answers Accenture, Cap Gemini, Systime, TCS,
how to Explain a complex report at the time of interview ? please post the answer very urgent?
What is the difference between regular dimension and derminant?
what was the actual purpose of portfolio in cognos ?
Which studio is used to create reports?
what is differences between the group span and levelspan
What are the main services provided by application tier?
how to create relationship between emp and salgrade tables in frameworkmanager?
Why do we create shortcuts in framework manager
What is the difference between cognos 8.2 and cognos 8.3?