https://community.qlik.com/t5/Talend-Studio/SCD-implementation-error-historical-loads/m-p/2313978#M84785 <P>I've tmap null pointer exception.</P> <P>I'm trying to design scd2 on an historical load.&nbsp;&nbsp;</P> <P>I'm getting a null pointer exception when I lookup on target table(which is empty). Is it possible to do this operation with this method? else how to implement SCD on historical data which has duplicates.(No SCDcomponent for redshift)<SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SCD.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LyF1.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/130438iADD735CEFACD6B04/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LyF1.png" alt="0683p000009LyF1.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="scd2.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LyFB.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/143909i7C2701C623FBF5A8/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LyFB.png" alt="0683p000009LyFB.png" /></span></SPAN></P> Mon, 25 Jun 2018 21:14:31 GMT Anonymous 2018-06-25T21:14:31Z https://community.qlik.com/t5/Talend-Studio/SCD-implementation-error-historical-loads/m-p/2313978#M84785 <P>I've tmap null pointer exception.</P> <P>I'm trying to design scd2 on an historical load.&nbsp;&nbsp;</P> <P>I'm getting a null pointer exception when I lookup on target table(which is empty). Is it possible to do this operation with this method? else how to implement SCD on historical data which has duplicates.(No SCDcomponent for redshift)<SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SCD.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LyF1.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/130438iADD735CEFACD6B04/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LyF1.png" alt="0683p000009LyF1.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="scd2.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LyFB.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/143909i7C2701C623FBF5A8/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LyFB.png" alt="0683p000009LyFB.png" /></span></SPAN></P> Mon, 25 Jun 2018 21:14:31 GMT https://community.qlik.com/t5/Talend-Studio/SCD-implementation-error-historical-loads/m-p/2313978#M84785 Anonymous 2018-06-25T21:14:31Z https://community.qlik.com/t5/Talend-Studio/SCD-implementation-error-historical-loads/m-p/2313979#M84786 it seam to be your output filter can you publish them (or try without any filter on output table) Tue, 26 Jun 2018 08:08:31 GMT https://community.qlik.com/t5/Talend-Studio/SCD-implementation-error-historical-loads/m-p/2313979#M84786 fdenis 2018-06-26T08:08:31Z https://community.qlik.com/t5/Talend-Studio/SCD-implementation-error-historical-loads/m-p/2313980#M84787 <P>Thank you, it is fixed.</P><P>The performance is bad.</P> Wed, 27 Jun 2018 18:08:00 GMT https://community.qlik.com/t5/Talend-Studio/SCD-implementation-error-historical-loads/m-p/2313980#M84787 Anonymous 2018-06-27T18:08:00Z