Hello Team,
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