DSXchange

Hello there, I am trying to merge two sequential files. I am trying to get the 'Complete Set' of these two files. When I am executing this job, I am getting the following error: Abnormal termination of stage MRG_ADDR_ADDR..Sequential_File_1.IDENT1 detected Can anyone help me with this. Thanx in adva...

Hello all,
Thank you very much for ur help.
-Yamini

Hello all,

Can anybody provide me a routine to validate e-mail address. I want to check the following condition to validate e-mail(xxxx@xxx.xxx).

Thanx in advance.
-Yamini

Hello all,
Thank you very much for your suggestions.
-Yamini

Hello there,

I designed a job which has about 20 stages in it. From the performance stand-point, would it be a good idea to design a job with so many stages especially when I can break this job into small jobs.

Thanks in advance.
-Yamini

Hello trokosz,
Thank you very much for your posting.
-Yamini

Hello there,
Is it possible to build a 'Hash file' with 20 million rows. Does it reach the limit of hash file size of 2GB. Can anyone clear my doubt.
Thanx in advance

-Yamini

Hello Ray,
Thank you for your suggestion.
-Yamini

Hello there,

Is there a way to de-quote a string. My intension is to remove the quotes from a input string.
Thanx in advance.

-Yamini

Hello there, I have the following columns in a table: 'Name', 'ssn, 'age'. The values for these columns are: SUN 6666 24 5555 26 Raj 7777 25 8888 23 The first column contains Null values. I am trying to separate this into two files based on the column 'Name'. I am using IsNull(Name) then 'file1' els...

Hello Man,

We are using Sequential File Stage.
-Yamini

Hello DJ, I used RowProcCompareWithPreviousValue routine to capture the duplicates. The only condition to meet here is to have the input file sorted on 'Key column'. Input File -> SEQ1 AND SEQ2. Where SEQ2 is the reject file. In the constraint of SEQ1 file mention RowProcCompareWithPreviousValue(Lin...

Hello there, I am trying to remove duplicates from a table with millions of rows. I am using a hash stage to remove the duplicates and collect the unique rows. But, I also want to capture the rows which actually are duplicated in the original table. Can anyone explain to me how to collect the duplic...

Hello there,

Can anyone explain to me the easiest way of combining two sequential files. My intension is to first place all the records of file 'A' and then place all the records of file 'B' into one file 'C'.

Thanx in advance.
-Yamini

Hello Ray,

Thank you for your reply. Now, I clearly understand about the log tables. Is there any way to redirect these log tables into a particular directory.

Thanx in advance.
-Yamini