topic Slowly Changing Dimensions ETL in QlikView https://community.qlik.com/t5/QlikView/Slowly-Changing-Dimensions-ETL/m-p/848744#M999876 <HTML><HEAD></HEAD><BODY><P>I have read up on the theory of Slowly Changing Dimensions via the post at <A href="https://community.qlik.com/docs/DOC-4310">IntervalMatch and Slowly Changing Dimensions</A></P><P></P><P>I have a query regarding the concept.</P><P>In almost all of the examples the start point is to have an interval table with a 'From Date' and 'To Date' or a table with a 'Changed Date' so that you can build up a 'From Date' and 'To Date'. </P><P></P><P>How do you handle cases where you do not have a change date because the source system does not record it? </P><P></P><P>For example you have a product file that changes product class but there is no last updated date?</P><P>On the assumption you cannot change the source system is the done thing to keep a comparison file of the products and product classes for a daily load update and identify the changes, adds and deletes to then build a QVD file with the intervals table showing 'From Date' and 'To Date'?&nbsp;&nbsp; Not got my head round whether or not QlikView can do that yet.</P></BODY></HTML> Thu, 18 Jun 2015 07:14:39 GMT rebelfox 2015-06-18T07:14:39Z Slowly Changing Dimensions ETL https://community.qlik.com/t5/QlikView/Slowly-Changing-Dimensions-ETL/m-p/848744#M999876 <HTML><HEAD></HEAD><BODY><P>I have read up on the theory of Slowly Changing Dimensions via the post at <A href="https://community.qlik.com/docs/DOC-4310">IntervalMatch and Slowly Changing Dimensions</A></P><P></P><P>I have a query regarding the concept.</P><P>In almost all of the examples the start point is to have an interval table with a 'From Date' and 'To Date' or a table with a 'Changed Date' so that you can build up a 'From Date' and 'To Date'. </P><P></P><P>How do you handle cases where you do not have a change date because the source system does not record it? </P><P></P><P>For example you have a product file that changes product class but there is no last updated date?</P><P>On the assumption you cannot change the source system is the done thing to keep a comparison file of the products and product classes for a daily load update and identify the changes, adds and deletes to then build a QVD file with the intervals table showing 'From Date' and 'To Date'?&nbsp;&nbsp; Not got my head round whether or not QlikView can do that yet.</P></BODY></HTML> Thu, 18 Jun 2015 07:14:39 GMT https://community.qlik.com/t5/QlikView/Slowly-Changing-Dimensions-ETL/m-p/848744#M999876 rebelfox 2015-06-18T07:14:39Z