Tuesday, 17 June 2014

XML Parser Transformation

  • XML Parser is an Active and Connected transformation.

  • XML Parser transformation is use to extract XML inside a pipeline. The XML Parser transformation lets you extract XML data from messaging systems, such as TIBCO or MQ Series, and from other sources, such as files or databases. The XML Parser transformation functionality is similar to the XML source functionality, except it parses the XML in the pipeline.

For example, you might want to extract XML data from a Flat File (data will be in XML Format) and pass the data to relational targets.
The XML Parser transformation reads XML data from a single input port and writes data to one or more output ports.

DBT - Models

Models are where your developers spend most of their time within a dbt environment. Models are primarily written as a select statement and ...

  • SQL Error : Multiple ResultSets were returned by the query
    Upon using the custom query in the source object, the mapping fails with the following error: The select query for read operation failed bec...
  • DATA MINING
    Data mining is the process of finding patterns from large data sets and analyzing data from different perspectives. It allows business use...