How can we find out cardinality between two tables?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.

1759


hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

1547


how you provide security to reports? How you provide security to packages ?

621


What are the types of security?

536


can we insert all types of charts in a list report? what r the realtime prompts?

1660






How can I schedule reports in cognos?

593


How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..

1551


What is the difference between Open Connection command ang Open Session Command?

1912


It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

1943


What do you understand by the term 'model durability'?

560


Explain what is the main advantage of impromptu over cognos reportnet?

597


What are slice and dice?

521


What are all the types of hierarchies?

668


What are the ways to import data into catalog?

626


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

1658