Circular ref :::

[#1]

Hi

I want one scenario for Circular Reference   ,

after loading the tables it will associate based on the primary key(comman key) ,

so  the data model look like not well but how it show the bad results means wrong results can anybody give one scenario and any other disadvantages .

Thanks

Madhu

[MK_QSL]

Circular References

[sujeetsingh]

Follow this too

Drawbacks of circular reference and Synthetic key

[SreeniJD]

"Qualify" statement definitely help you to avoid synthetic key and circular reference

HTH

Sreeni

[#5]

Thank u Sreeni, 

I am not asking how to solve the circular ref , i am asking how to show the bad results .

Thanks

Madhu

[SreeniJD]

Madhu - You might be aware that when you have common keys across dimensions, circular references will be formed... so the best example is have two tables, one with 100 rows and another with 2/3 rows of data and form a circular reference.

What you can observe with a circular reference is, your query may get data from table2 which has less rows and actually you might expect the result from table1 where you have good data.. because of loosely connected tables

Sreeni