Cognos Blog

website design company in bangalore Cardinality – Combination Join and Occurrences City Table Country Code City Code City Name 101 201 New York 102 202 Hyderabad 102 203 Mumbai 103 204 London 105 205 Tokyo Join Country Table Country Code Country Name 101 US 102 India 103 UK 104 Australia ·       Joining using Country Code column from both of the tables 1 .1   to     1 .1 - Inner Join - Fetches only matching records Country City US New York India Hyderabad India Mumbai UK London 0 . 1   to     1 .1 - Right outer Join - Fetches matching records + Right side non-matching records Country City ...