This discussion is archived
2 Replies Latest reply: Mar 27, 2013 8:58 AM by 998980 RSS

Standard Oracle DDL for W_PARTY_D

832697 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points