This content has been marked as final. Show 2 replies
Do you want to know how to get the same without asking any one?
Logon to Informatica designer->Target Designer
Pull the table
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
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.