DSXchange

Thanks guys I am looking if some one can give their earlier experiences, i had the following scenario i had a job which used to process around 100,000 records in 1&1/2 hour on one node which used to process around 100 columns from a SQL server (using ODBC) connection to a Sequential file. so if ...

Hi,

Can any body say what would be the approximate time that would take to process 10 million records in a server job which has the following sequence of stages

source>sort>transformer>target

is there any formula to calculate the processing time.


ThanX
Von

Thank you Ken,

that should solve my problem, let me try,
Once again Thank youVery much


Von

Hi Ken,

now what i want is i need to capture these values in the target and then abort the job

ThanX
Von

HI Ken, The soulution you have given is good but i have a case which is quite different let me be clear on the question. i have 6 columns in the source i need to check for NULL on 5 columns 1st column being primary key column then 2nd column i need to check for NULL and if it is NULL i have to throu...

Thanks, but my case is like this i have around 6 columns on which NUll check has to be performed if any of the column has null value i have to capture the primary key details of the record in the target sequential file and then abort the job. say, if i check for NULL condition on individual column i...

Hi,

Can anybody suggest a method fo the following cenario


i have a job to check for NULL on a column if the condition satisfies i need to capture the details of the key column in a sequential file and then abort the job.

Thanks
Von

Thank you Srikanth & Ray

That solves my problem

Von

Thanks mike and Duke

I was also thinking of the same way if anything else please let me know


Thanks again
Von

Hi,
Can anybody tell me how Referential integrity is handled in
DataStage,

Say we have two Oracle tables
i want to check if The column data present in table 1 has the corresponding value in table 2 this check has to be performed on Fk on the table2 PK is on the Tabe1

Thanks
von