DSXchange

Another question regarding the same topic, to import the stored procedure definitions, it seems like i must use ODBC, why can-t I do it the same way as with the tables, using the ORACCLI or whatever it is called?

Or am I missing something here?

BR
/Elin

Hello, I'm wondering about the Stored procedure stage in the database palette of DataStage. We are using Oracle as database for our datawarehouse solution and are wondering if we can make use of this stage? In other words, are the stage using an ODBC connection to connect to the database or is it us...

Thanks, I though that might be the answer.

I,m sorry to step into this conversation but with automatic load in oracibil do you still need to use sqlldr or will the data be automatically put into the given table?

BR
/Elin

I had made an error in the standard load using transformer, it is as fast as using BULK load. About 6000 ros/sec. What I don't understand is how it looks in DataStage. If the bulk load is supposedly loading all data at ones, how comes the writing from the transformer is ticking in the same performan...

Some more information. When using oracle OCl Load and the transformer I get a loading performance of about 5000rows/sec. I stopped it after about 6 million rows, had taken 30 mins. When using the same OCl Load directly, adopting the table to exactly match the filedata (not optional, only for test) I...

which one is faster? Is it the load where ypu afterwards manually run a script with sclldr or is it the OCl load with automatic mode?

I rather use the automatic one if there is no difference because I don't really get the after_subprocedure or how to use sqlldr with it.

BR
/Elin

Aha, after searching a bit more I found out that I have the automatic option on the Oracle OCI load but not in the Oracle 7 load. What is the difference between theese two? Can I use any of them? Also it does not seems to be loading very quick when using bulk load compared to normal load. Am I doing...

I have ben set the taskt to try to speed up some data loads by using bulk load instead of the standard oracle OCI. I am supposed to try both the Oracle OCI load and the Oracle 7 load. After reading a little about it in this forum I hace come to understand that the automatic mode might be something o...

Thank ypui all very much for your answers! I think I have solved the issue for the moment with your help.

I'm terribly sorry to bother you again but I just realaised that althoug I am using a windows client for running datastage. The server is actually a unix server and the batch program should therefore be for UNIX. A quick question therefore, can't find it on google: How do I write the syntax for grep...

sounds good that my way is possible, but is it an ugly way of solving it? I want it to be as generic as possible. For the time being we are only to use the number of rows but the header contains a lot more information that could be useful. The line I want to read looks something like this: 1010LA 20...

My tought was to first read the first line from the file using dataStage, and load it into a new file that I then sould use to compare with the whole set. Is this a bad option, the reason is that I have no idea how to read the file using a command. How do I write the command file? What programming l...

thanks, Execute command sounds like a good option. I am not sure how to use this though. Do you have any example?

Br
/Elin

I have a complex flat file that starts with a header that includes the number of records in the file. I want to use this information to check both if the number of records in the file matches the header and when readeing these records into a database, see if I get all records i.e if the number of ro...