<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic SCD in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/SCD/m-p/2370467#M133505</link>
    <description>I have a requirement where "source key" column is a SCD type 2 field. The field can be either under "SOURCE KEY" or under TYPE 2 Field. I am not able to use the same column in both the places. &lt;BR /&gt;&lt;BR /&gt;source table (col1, col2, col3,col4 has unique index)&lt;BR /&gt;col1 , col2 , col3 , col4 , col5&lt;BR /&gt;SCD screen&lt;BR /&gt;Source key - col1, col2, col3,col4 &lt;BR /&gt;Type 2 field  - col3 , col5&lt;BR /&gt;I am able to place  col3 either under "SOURCE KEY"  or under Type 2 Field&lt;BR /&gt;How can I acheive this?</description>
    <pubDate>Tue, 15 May 2012 20:49:21 GMT</pubDate>
    <dc:creator>_AnonymousUser</dc:creator>
    <dc:date>2012-05-15T20:49:21Z</dc:date>
    <item>
      <title>SCD</title>
      <link>https://community.qlik.com/t5/Talend-Studio/SCD/m-p/2370467#M133505</link>
      <description>I have a requirement where "source key" column is a SCD type 2 field. The field can be either under "SOURCE KEY" or under TYPE 2 Field. I am not able to use the same column in both the places. &lt;BR /&gt;&lt;BR /&gt;source table (col1, col2, col3,col4 has unique index)&lt;BR /&gt;col1 , col2 , col3 , col4 , col5&lt;BR /&gt;SCD screen&lt;BR /&gt;Source key - col1, col2, col3,col4 &lt;BR /&gt;Type 2 field  - col3 , col5&lt;BR /&gt;I am able to place  col3 either under "SOURCE KEY"  or under Type 2 Field&lt;BR /&gt;How can I acheive this?</description>
      <pubDate>Tue, 15 May 2012 20:49:21 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/SCD/m-p/2370467#M133505</guid>
      <dc:creator>_AnonymousUser</dc:creator>
      <dc:date>2012-05-15T20:49:21Z</dc:date>
    </item>
    <item>
      <title>Re: SCD</title>
      <link>https://community.qlik.com/t5/Talend-Studio/SCD/m-p/2370468#M133506</link>
      <description>Hi
&lt;BR /&gt;I don't think you can do this.
&lt;BR /&gt;The function of Source key is to ensure the unicity of the incoming data which is forbidden for updating.
&lt;BR /&gt;Type 2 field is the field which can be updated.
&lt;BR /&gt;The concepts of Source key and type 2 field are conflicting.
&lt;BR /&gt;Regards,
&lt;BR /&gt;Pedro</description>
      <pubDate>Wed, 16 May 2012 07:56:15 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/SCD/m-p/2370468#M133506</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2012-05-16T07:56:15Z</dc:date>
    </item>
  </channel>
</rss>

