DSXchange

Thanks to ALL, day before yesterday, I have resolved it by using all u ppl inputs and I did following changes and it worked, In transformer i am doing 2 thing in stage variable, 1. StgVar1 = If IsNull(Src col 'A') then "#" else DecimaltoString(Src col 'A', "suppresszero") 2. StgV...

Actually i am bring in Source with this couple of records with NULL and i need to push these record (with NULL) as it is in Target....and my soucre (Dataset) and Trg (Teradata Enterprise Stage)..... Note: In transformer i am doing 2 thing in stage variable 1. StgVar1 = DecimaltoString(Src col 'A', &...

Please let me know wht changes that i should do to job but with retaining "StgVar1" and "StgVar2"...stage variables in transformer....
Also i need this record with Null to load from Src col 'A' (dataset) to Trg col 'A' (Teradata).....

Hi, I have simple job with Dataset ---> Transformer ---> Teradata Enterprise Stage Ex: Null Record ---- 1, ABC, 0, NULL, 10 Job is completing with following warning: "For Trg Col 'A' cannot load with Null so Record dropped." i.e. Its loading all records except 3 records which has Null in S...

ray.wurlod wrote:Do you have a D:\tmp folder? You need one. This is referred to as /tmp by MKS Toolkit. ...

Hi Ray, i have made the changes and now it working. Thanks Dude!!!!

In Ds-Manager, if i check configuration default file i am getting below error. Before installing Datastage ver 7.5x2 on OS-2003 Server, i have installed MS-VC++ .Net 2003 too. Below are the details of Default configuration file and Compilation Error. Please let me how to configure the default file i...