1 Reply Latest reply: Jan 21, 2013 9:18 PM by John A Booth RSS

    Import Integration Script

    vnm
      Hello Guys,
      I want to pull the specific data from two different tables from oracle database . what should i do ? is it possible to import data from two different tables using import integration script or i need to write SQL query for this ?

      Any one have sample script for same issue ?
        • 1. Re: Import Integration Script
          John A Booth
          Hi Vnm,

          See page 91 of the FDM Admin guide at:
          http://docs.oracle.com/cd/E17236_01/epm.1112/fdm_admin.pdf

          Yes you can access multiple sources from an integration script and yes as you are hitting a database you will need to execute a SQL statement as part of the integration script.

          The example on 91 does use SQL which is typical for integration scripts.

          Regards,

          John A. Booth
          http://www.metavero.com