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 |
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.
What are the two types of framework manager?
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
Explain the difference between native sql and cognos sql?
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?
how to create measures and dimensions?
how to create relationship between emp and salgrade tables in frameworkmanager?
In framework Manager, what is a stitch query and is it good or bad?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
can we create a chart without measure
what is the main advantage of impromptu over cognos reportnet?
What are the roles defined by cognos platform?