1. TARGIT Community
  2. Community
  3. Data Warehouse Developer
Knowledge Base

Xml-file as datasource in an InMemory project.

Ole Jørgensen ·

I need to build an InMemory project having an xml-file as input. I have added an xml datasource but can not figure out, how to use it in an import query. An example would be very much appreciated. My input-file is similar to this:

0

Comments

1 comment
Sort by DateVotes
  • Jesper da Silva Endelt

    Hi Ole,

    I've created a small example based on a XML structure like this:

    I connect to the XML file and uses a SQL like this with a Import task:

    SELECT * FROM dvd

    If you need actors, then use this:

    SELECT * FROM actor

    Does this help?

    Best regards,

    Jesper da Silva Endelt

    0
Please sign in to leave a comment.