Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changing cardinality

Status
Not open for further replies.
sraj1

sraj1

Technical User
Dec 12, 2006
13
US
Is it safe to chane the cardinality between two tables, from A(1:1)-B(0:n) to A(1:1)-B(0:1), assuming table B doesnt have any fact data.
 
Sort by date Sort by votes
Cardinality is basically there to detect facts and ensure more complex query solving is met. The type of cardinality you propose would be used in snowflakes (where 2 dimensions are joined). Is it safe? It should be for non-facts

Ties Blom

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

oneorangeshoe
  • Locked
  • Question
Changing Paramdisplayvalue from comma separated to semi colon separated
Replies
1
Views
52
blom0344
blom0344
kcog123
  • Locked
  • Question
Changing data item names in Report Studio
Replies
3
Views
82
blom0344
blom0344
Manish02
  • Locked
  • Question
Changing DB links depending on the selected parameter
Replies
0
Views
26
Manish02
Manish02
DrSmyth
  • Locked
  • Question
Changing Default Excel File name
Replies
0
Views
33
DrSmyth
DrSmyth
Crurraca2010
  • Locked
  • Question
Report Studio Crosstab with changing Dimension
Replies
0
Views
12
Crurraca2010
Crurraca2010

Part and Inventory Search

Sponsor

Back
Top