2 Replies Latest reply: Mar 27, 2013 10:58 AM by 998980 RSS

    Standard Oracle DDL for W_PARTY_D

    832697
      Hi,

      Can someone please provide me the standard DDL for table W_PARTY_D w.r.t. Oracle Database 10g.

      I do not find it in any files in that are there in the following folders:
      c:/oraclebi/dwrep
        • 1. Re: Standard Oracle DDL for W_PARTY_D
          Srini VEERAVALLI
          Do you want to know how to get the same without asking any one?

          Logon to Informatica designer->Target Designer
          Pull the table
          Menu->Target->Generate/Execute SQL...

          Check option at 'Generate options' and then click on 'Generate SQL file'
          and then 'Edit SQL file'

          If helps mark as correct

          Edited by: Srini VEERAVALLI on Mar 27, 2013 9:14 AM

          I would assume you would do this (as I said) in Informatica folder SILOS, since we go for custom folders for any customization and the
          OOB folders remain untouched and have OOB data definition.

          I dont think any other method would help you to get this.

          Edited by: Srini VEERAVALLI on Mar 27, 2013 11:32 AM
          • 2. Re: Standard Oracle DDL for W_PARTY_D
            998980
            If you have SQL developer or toad, just browse to table, and click on 'scripts' for toad, or SQL for SQL developer. You should get DDL right there.