We have an scenario where we need to read the data from the Table in SQL SERVER database. Table will contain 3 String field and 1 CLOB field, The CLOB field will contain the complete dump of XML. The table will contain ~1000 ie 1000 XML.
ID
Date
Name
DATA (CLOB)
1
1/1/2020
Policy1
<DATA> ……..</DATA>
2
1/1/2020
Policy2
<DATA> ……..</DATA>
3
1/1/2020
Policy3
<DATA> ……..</DATA>
We need to design a Talend Job to read the data from Table and create 1000 XML with name from NAME field dynamically using single Talend Job. Any suggestion/ Input is much appraciated.
@nthampi@skiran - Any suggestion /Input would help !! Thanks
