<?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 tMap with dynamic length in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/tMap-with-dynamic-length/m-p/2302292#M74295</link>
    <description>Hi.&lt;BR /&gt;&lt;BR /&gt;I am pretty new to using Talend as an ETL tool .&lt;BR /&gt;&lt;BR /&gt;I am performing ETL from Sybase db -&amp;gt; tMap -&amp;gt; dboutput to MSSQL.&lt;BR /&gt;&lt;BR /&gt;The problem I am facing is the schema for MSSQL. Say if I define the column to be of dtype string length 20, data mapped to this column will be forcefully created as a len 20 character, with unecessary white spaces .&lt;BR /&gt;&lt;BR /&gt;May I know what are the available options for me to perform my ETL and ouput to MSSQL without this constraint i.e. taking the string from the source data as it is.&lt;BR /&gt;&lt;BR /&gt;Thank you&lt;BR /&gt;&lt;BR /&gt;</description>
    <pubDate>Mon, 20 Aug 2018 11:59:33 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2018-08-20T11:59:33Z</dc:date>
    <item>
      <title>tMap with dynamic length</title>
      <link>https://community.qlik.com/t5/Talend-Studio/tMap-with-dynamic-length/m-p/2302292#M74295</link>
      <description>Hi.&lt;BR /&gt;&lt;BR /&gt;I am pretty new to using Talend as an ETL tool .&lt;BR /&gt;&lt;BR /&gt;I am performing ETL from Sybase db -&amp;gt; tMap -&amp;gt; dboutput to MSSQL.&lt;BR /&gt;&lt;BR /&gt;The problem I am facing is the schema for MSSQL. Say if I define the column to be of dtype string length 20, data mapped to this column will be forcefully created as a len 20 character, with unecessary white spaces .&lt;BR /&gt;&lt;BR /&gt;May I know what are the available options for me to perform my ETL and ouput to MSSQL without this constraint i.e. taking the string from the source data as it is.&lt;BR /&gt;&lt;BR /&gt;Thank you&lt;BR /&gt;&lt;BR /&gt;</description>
      <pubDate>Mon, 20 Aug 2018 11:59:33 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/tMap-with-dynamic-length/m-p/2302292#M74295</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-08-20T11:59:33Z</dc:date>
    </item>
  </channel>
</rss>

