Skip to Content
Jan 27, 2009 at 01:17 AM

data transfer transform with Oracle


I am using a data transfer transform within a simple data flow.

Source --> Query --> data transfer --> two queries --> two target tables.

The transfer type is set to Table. The table is being created in a oracle 9i datastore. I have the drop and re-create before loading box checked. I execute my simple job and everything runs fine. When I go to my database to look at the contents of the table created within the data transfer transform, I cannot find the table (have USER with select any table privs).

Where does the table go? Is it immediately dropped after it is used? If so, is there a way to override this? Having the table/contents hang around until the next time I run the job, is extremely helpful with debugging.