Importing columns

[phanikumar]

Hi,

I am using oracle enterprise stage as a source and i am writing a user defined query which is joining on two different tables.The result of this query will be populating some 50 to 60 columns and my question is in order to define the columns in the source what is the best method to import these columns other than typing them manually.

Regards

kumar

[SURA]

store the columns as a , delimited values and save it in a text file and import the metadata.

DS User

[BillB]

In the database, create a view based on your query. Then import the table definition of the view.