Answer Detail: RE: Parent-Child Relationship

GeekInterview.com > Interview Questions > Data Warehousing > MicroStrategy

Print |

Question: Parent-Child Relationship

Answer: What is the primary need for maintaining the Parent-Child relationship for attributes?

December 12, 2008 04:18:11	#2
ucontactkumar	Member Since: December 2008 Total Comments: 1
RE: Parent-Child Relationship
If parent child relationship is not established it results in unwanted joins. As a result of this metric values are not retrieved properly due to improper joins. And alos it results in cross join which is deeply resource intensive and affects the performance.