DSXchange

I am not updating any of the primary index

I am adopting this way because my where condition does not have every key column of the table. Table1---->updating--->Temporary_Table1 API MLOAD Table1 ===== Actually the table has 7 key columns. My job has brought in just 2 of the key columns from the source. The steps I am following are : ========...

Hi, I have been using the Mload stage to update 1 million records in a table. The rows/sec or rather the performance of the update is low. I am doing a migration project from Oracle to Teradata. The performance when compared to the oracle job is poor The stats are Oracle job updates the target at th...

Hi, Thanks a lot on the update. I guess I will be able to work on it this week..since IBM is working on installing the patch... ..and it helped me in updating the client about a lil info. Regards, Alan Hi Alan, The new Teradata Connector Stage is available only for Parallel Jobs and has two modes of...

Hi All,

Can anyone please let me know the extra features of the teradata connector ?

Im not sure whether the fix released by IBM is for server , parallel or both.

Can anyone please give some insight about the connector on how different is it from teradata API Stage

Cheers!!!

Alan

Thanks A lot...It worked out fine... :D

Hi, I had tried creating a c program for removing unwanted characters in the string and it works. FUNCTIONALITY ========== ROUTINENAME("A~b~C")---> AbC The code is like this....(It worked when I put the main ()) ================== replace_al ================== #include <stdio.h> #include <...