DSXchange

Thanks Sura for the Suggestion.

I started writing the PROC, before that I just want to know whether any others come across the same situation and their ideas about this?

And regarding the Indexes, Yes the tables are having the indexes on the columns which I am using in joins.

Hi All, I have a query regarding the tuning a datastage job. My requirement is to read 10 millions of data from a table and do a lookup (Left outer join) on some other table which is on same database, then insert the data into some other table. My ETL job for above requirement is taking more than 10...

Hi theone, Thanks for the reply. But in some cases, we can see these two different kinds of warnings from same table. That means, job is having only one table with PRIMARY_KEY and NOT NULL columns, so records are rejected due to PRIMARY_KEY violations and some other are due to NON NULL constraint. B...

Hi All,

Any ideas of this issue, I am still trying for some work around. Any one can suggest?

Hi All, I need to insert data coming from a file into two different target tables. First table is having a PRIMARY-KEY and second table is having some NON NUL able columns. I added a message handler in my job to handle PRIMARY KEY violation warnings (I created a new message handler to handle the mes...

Thanks Ray, I got it now.

Hi All,

Is there any way to copy the dataset data into a sequential file?

I need to write a UNIX script which will accept dataset name as input parameter, read that dataset and copy the data into a specified sequential file.

Is it possible to do this using shell scripting?

I need to read a sequential file that is created in some other processses .It is created with the following options Record Level Final delimeter =end Record Delimeter String =Dos format Field Defaults Delimeter = tab Null field value = ' ' I need to read the file as a single row. By using server job...

Length's are same for all the columns Ray. Only VARCHAR to NVARCHAR and CHAR type to NCHAR are converted while importing the metadata.

And regarding the UNICODE, can you please explain a bit more?

Hi All, I have a job which update data in a table in Oracle. While importing the metadata from datastage by using ODBC meta data connectivity, Datastage converted all VARCHAR datatypes into NVARCHAR type. I am using the same meta data while updating the same table after few joins in my job. This job...

Thanks Arndw, I am not doing the updates. Some other system will do the updates and that updates will flow into my system. I can find changes only by comparing before and after images. Any performace tunning methods before using CHANGE CAPTURE stage. I am sorting the data other than this any other t...

Thanks Arndw, I am not doing the updates. Some other system will do the updates and that updates will flow into my system. I can find changes only by comparing before and after images. Any performace tunning methods before using CHANGE CAPTURE stage. I am sorting the data other than this any other t...

Hi, I have a requirement to compare a table before update and after update. I have 10 columns in each record and table is having around 20 millions of records. I want to run a comparison over 20 millions of records. In this case, is it feasible to use CHANGE CAPTURE stage to get the differences (ins...

Thanks Chulett,

That solved my problem.

Thank you very much..

I got a work around for this. I am addding the current timestamp in the name of the file, FTPing through the .bat script in windows.

I am dropping the Datastage job which is doing FTP as there is no way to pass dynamic timestamp to the file name in FTP stage.