Any help that can be provided concerning the following challenge would be helpful:
I’ve just stepped into an environment with lots of data across multiple platforms, so TDA seems like just the ticket. A primary need is to compare data sets from different sources using outer joins and subqueries in order to determine when data is dropped when passing from one system to the next. Because neither outer joins or subqueries are supported when creating heterogenous queries, the alternative seems to be to write a script that does a SQL select, outputs to a CSV, and dump the results into a database instance where I have write privleges. Repeat with another source, and I end up with the pieces I need where I can manipulate them.
Coming from Teradata to a CSV to an Oracle table works fine. The qualifiers here are that I’m outputting and importing a single column, and that I’ve created my target table in advance - the create new table on the fly methodology doesn’t seem to provide any success.
Coming from one Oracle instance to another remains problematic. In this case I’m using 6 columns to a CSV. I’ve created my target table in advance. The column order doesn’t match, I’m mapping by names (one column name doesn’t match, I used the dialog to specify it). I can write to the CSV file just fine, but on the step that imports to the table I get a break that has a cryptic error, pasted below.
I am using CSV’s in preference to Excel because I can do an overwrite of the file. The Excel option seems to perform better with the interface, but it writes a new worksheet tab on the second pass, and I haven’t figured out a way around that.
The error message is:
Object reference not set to an instance of an object.
Error log is attached.
Thanks for any and all help!
Stucky 4809 Analysis.log (8.05 KB)