Dynimically load table text,Xml values into ETL Pentaho JOB

149 views Asked by At

I am very new to Pentaho. I have one table, it has type column which has different data, such as XML, text.

Here I am sending ex of type data: Type :

1."<HIntDetails>  <sKey>3</sKey>   <pID>132</pID>  <SName>Holt, R A</subjectName>  <facilityId>H</facilityId>  <facilityId>C</facilityId>  <summaryView>false</summaryView>  <timestamp>2013-12-30 (...)"     ---XML
2."<cliMessageKey>707</clinicalMessageKey>"
3."<details>  <methodName>getSourcesByFilter</methodName>  <parameters>                -----XML
<string>FacilityFilterModel{simpleStr=&apos;null&apos;, globalIdFuzzy=&apos;null&apos;, globalId=&apos;HEC&apos;, exactOnId=true, label=&apos;null&apos;, consumerOfLabs=null, creato (...)"         -------XML
4."PKey=77 SKey=30 pNameFormatted=Hoon, M F method=CONVERTER"              --text

Now I have to read this table and update the target table.

My target table has the below fields:

Skey
Pkey
Pgroup
PID

I have to read that table type column and I need to update the target, but I am not sure which tasks I need to accomplish this one.

0

There are 0 answers