DSXchange

chulett wrote:I don't see anywhere that the OP mentioned the FTP stage.

Sorry I assumed.

Hi Craig, While doing the ftp I specified it to be in binary representation. I thought that should be enough. Is there anythign else I need to check for? Thanks Are you really stuck on using the FTP stage? If not I would just set a script up to binary ftp the files to the DataStage server then use ...

I need to correct my previous statement. There does seem to be tools out there that convert the stored procedures. A quick google search turned up the following:

http://www.ispirer.com/products

Vaishali,

I am pretty sure that this is not a something that you will be doing in datastage. :D

I have seen some tools advertised that claimed to take an Oracle Stored Procedure and convert it to a SQL Server one, but not the other way around.

Speaking from experience, I would also make sure you do an explicit conversion of the data type from character to date. In the SQL Server example using CONVERT or with Oracle the TO_DATE.

You would use the pivot stage. It is a little tricky to use but there are several good discussions on it in theis forum.

We are currently running 7.5 under windows with the Oracle 8.1.7 client installed and going after data from an Oracle 7.3.4 database using the Oracle 8 native stage. We are not having any problems because the SQL*Net client can connect to the older server. In addition you will need to watch the SQL ...

Ogmios, We use the IPC stage quite frequently in this type of a scenario and have seen some significant performance benefits. It has less with paralleization of the processing of rows and more with splitting the processing of the single stream across multiple processors. The biggest benefit we have ...

I've a very simple job: SeqFile->Transformer->SeqFile. I want to improve a performance. There is a multi-processor system. When I use the IPC stage I have a great performance. But when I specify it implicitly by turning inter process row buffering on via Data Stage Administrator, a speed of reading...

Shawn, I don't see a BCP stage in 7.1r1 for Windows (on the distribution CD). Only SQL Server bulk stage is "Microsoft SQL Server Bulk Loader". Do you have both? On what platform and release? -Craig We are running 7.5 under Windows and are using the SQL Bulk loader so I never noticed when...

Thanks, the helps some. And yes, the DS stage doesn't need the format file, but it's not very performant. Craig, I am assuming that you have done some performance testing with BCP vs. DS bulk load. Are you using the SQL Bulk Load stage or the BCP stage? We have had some issues with performance of t...

Why not create a view on the SQL Server database that does the query to the linked table. Once you have imported the metadata you can drop the view and use the fully qualified (4 part name) in the ODBC generated SQL. Better yet leave the view and use it for the ETL.

We are using the IBM iSeries Access for Windows software. From what the AS/400 folks have told me comes with the AS/400 OS installation. On that disk there are several free components, one of them being the ODBC and OLEDB drivers. I am not an expert on the AS/400 but I believe that there is also a s...

While i connect to datastage the connection always breaks.then when i restart it works fine for a few minutes and then again it says connection is broken.Please suggest a solution as all the jobs break on the server. Are you using the Omit on the login? If so don't. We have had simular issues and s...

A Pivot Stage? That sounds like it would work, but I've never heard of such a thing. Could you explain where you find a pivot stage in datastage? I mean under what grouping on the palette? It is under the Processing Palette and looks like a box with an arrow pointing up and another pointing left. T...