https://community.incorta.com/t5/administrative-discussions/sparse-snapshot-w-header-and-detail-tables/m-p/4638#M180 <P>So I'm putting together a ( ? ) sparse snapshot table or tables e.g. order header and order lines where I want to capture changes which happen at either the header or the line.</P><P>Individually I have it, but since header and lines can get independent AsOfDates&nbsp; how do I go about joining header to line to avoid a many-to-many relationship?&nbsp;&nbsp;</P><P>OR - am I best off just joining them in the SQL and then creating the snapshot of the new, combined header/line table and only dealing with one AsOfDate?&nbsp; &nbsp; &nbsp;( making the combination of header and line keys the key columns on the new table )&nbsp;</P> Wed, 05 Jul 2023 15:36:04 GMT RADSr 2023-07-05T15:36:04Z https://community.incorta.com/t5/administrative-discussions/sparse-snapshot-w-header-and-detail-tables/m-p/4638#M180 <P>So I'm putting together a ( ? ) sparse snapshot table or tables e.g. order header and order lines where I want to capture changes which happen at either the header or the line.</P><P>Individually I have it, but since header and lines can get independent AsOfDates&nbsp; how do I go about joining header to line to avoid a many-to-many relationship?&nbsp;&nbsp;</P><P>OR - am I best off just joining them in the SQL and then creating the snapshot of the new, combined header/line table and only dealing with one AsOfDate?&nbsp; &nbsp; &nbsp;( making the combination of header and line keys the key columns on the new table )&nbsp;</P> Wed, 05 Jul 2023 15:36:04 GMT https://community.incorta.com/t5/administrative-discussions/sparse-snapshot-w-header-and-detail-tables/m-p/4638#M180 RADSr 2023-07-05T15:36:04Z