CODEWITHSUNDEEP
xmlfile-handlinginformaticainformatica-powercenterclob
dreadnought303
dreadnought303

Reputation: 157

Informatica Powercenter - Load contents of XML file to CLOB column

Is it possible to pick up an XML file via Powercenter and load the entirety of it into a target table's CLOB column? I have some code which is currently doing this completely in Oracle, but would like to perform the same process in Powercenter.

Or is the only option to call an procedure from within Powercenter to perform this insert?

Upvotes: 1

Views: 469

Answers (1)

Koushik Roy
Koushik Roy

Reputation: 7407

of course its possible.

  1. Set the DB target field as clob if not done already.
  2. Set the FILE source field as text with length like 100000. Pls note there can be some issues if its too large. Need to test it out.
  3. All transformations should use string/text data type with length as 100000.

Pls note, there can be some perf problem if you are trying to do some transformations to this field.

Upvotes: 1

Related Questions