What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

-- Download XML_Pipeline Transform as PDF --


Note on XML_Pipeline Transform: This deals with XML Sources and process large XML files into smaller pieces.

Options: No Options for this transform

Rules:

  • You can’t drag the main ROOT to Out schema.
  • You cannot connect XML_Pipeline from any other source other than XML type.
  • You can have one or more XML_Pipeline transforms in your design.
  • Once you dragged any child level column to out schema, you cannot drag the entire parent schema to out schema.

xml_pipleline3

Desgin Steps: My source contains nested schema, i want to unnest and load it into a table.

  • Drag your XML source from Fileformats (Either XML Schema or DTD), now place XML_pipeline transform on to the workspace and connect it from source.
  • Drag a template table to set as a TGT table.
xml_pipleline1
  • In my XML source, i have data like this

xml_pipleline2

  • Dbl. click on the XML_Pipeline transform, now drag the columns which you want.
xml_pipleline5
  • Here i dragged EMPNO, ENAME, SAL columns from parent schema and DEPTNO, DNAME,LOC from sub schema. Observe the out schema, it contains unnested data.
  • Now check the TGT data.

xml_pipleline4

Will post more examples later.

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

One comment on “XML_Pipeline Transform

Leave a Reply

Your email address will not be published. Required fields are marked *


*