https://community.qlik.com/t5/Talend-Studio/SCD-Date-Insert-update/m-p/2375512#M137917 Hi<BR />Which version of TOS do you use?<BR />I tried to reproduce this issue under TOS 5.1.0 but failed.<BR /><PRE>NOK: If some source Data change and the currentDate it's type 0 in SCD component. (The records were uptates and the Field remains like the first Insertion)</PRE><BR />The definition of SCD type 0 is values remain as they were at the time of the dimension record was first entered.<BR />So it's OK.<BR /><PRE>NOK: If the source Data was the same and the currentDate it's type 1 in SCD component. (All records assume the new Date without any change)</PRE><BR />What do you mean "All records assume the new Date without any change"?<BR /><PRE>NOK: If some source Data change and the currentDate it's type 1 in SCD component. (The records were uptated and all records assume the new Date even the records without any change)</PRE><BR />Can't reproduce.<BR />Regards,<BR />Pedro Mon, 21 May 2012 07:42:50 GMT Anonymous 2012-05-21T07:42:50Z https://community.qlik.com/t5/Talend-Studio/SCD-Date-Insert-update/m-p/2375511#M137916 Hi, <BR />I'm using SCD component with SDC Type 1. I have a Data field in my target table to mark the record with the date of insert or update. <BR />My source don't have information deltas and I process all records every day. the 1st time that I run my job I populate my date field in target with the currentDate and the problem occurs when I have to run the job again. <BR />I have this scenarios: <BR />OK: If the source Data was the same and the currentDate it's type 0 in SCD component. <BR />NOK: If the source Data was the same and the currentDate it's type 1 in SCD component. (All records assume the new Date without any change) <BR />NOK: If some source Data change and the currentDate it's type 0 in SCD component. (The records were uptates and the Field remains like the first Insertion) <BR />NOK: If some source Data change and the currentDate it's type 1 in SCD component. (The records were uptated and all records assume the new Date even the records without any change) <BR />I don't want to use triggers in database and I'm trying to avoid to use tMap and target LKP instead of SCD. <BR />Any solutions for this scenario? <BR />Regards Fri, 18 May 2012 12:27:04 GMT https://community.qlik.com/t5/Talend-Studio/SCD-Date-Insert-update/m-p/2375511#M137916 Anonymous 2012-05-18T12:27:04Z https://community.qlik.com/t5/Talend-Studio/SCD-Date-Insert-update/m-p/2375512#M137917 Hi<BR />Which version of TOS do you use?<BR />I tried to reproduce this issue under TOS 5.1.0 but failed.<BR /><PRE>NOK: If some source Data change and the currentDate it's type 0 in SCD component. (The records were uptates and the Field remains like the first Insertion)</PRE><BR />The definition of SCD type 0 is values remain as they were at the time of the dimension record was first entered.<BR />So it's OK.<BR /><PRE>NOK: If the source Data was the same and the currentDate it's type 1 in SCD component. (All records assume the new Date without any change)</PRE><BR />What do you mean "All records assume the new Date without any change"?<BR /><PRE>NOK: If some source Data change and the currentDate it's type 1 in SCD component. (The records were uptated and all records assume the new Date even the records without any change)</PRE><BR />Can't reproduce.<BR />Regards,<BR />Pedro Mon, 21 May 2012 07:42:50 GMT https://community.qlik.com/t5/Talend-Studio/SCD-Date-Insert-update/m-p/2375512#M137917 Anonymous 2012-05-21T07:42:50Z