DSXchange

I will check with option provided and come back if it works, Thanks for the information provided

Please ignore the word CART, take 1 input file and other Control file

Hi, I have 2 files CART input file and CART control file. 1. The CART input data file will have an number of rows. Eg. VIS.DAT CART control file will be having the told number of records present in CARTinput file. Eg.. VIS.DAT 55000 Question: How to compare the number of records present in CART inpu...

Hi, I have 2 tables Table ABC and Table DEF Table ABC FACTOR_NBR,FACTOR_NM .50----> SQI .00----> BAG .00----> COMP .50----> PROFIT Table DEF PROFIT_INDX SRVC_QLTY_INDX COMP_INDX BAG_INDX SRVC_RECOMND_INDX ------------ > To Update Based on the values of Table ABC, I need to do the calculations (below...

Without two passes you can not calculate percent, rank or any other value that depends on the total count or value.

How to do this, still not able to figure out

We do not have Oracle in this project, its Teradata and Datastage. We are converting from Oracle to Teradata

Hi, I am loading data into Sequential file.Before loading data into the file doing Null Handling.Below code ..... If IsNull(Move_EmplData.Addr_Street) Then '' Else If trim(Move_EmplData.Addr_Street) Then '' Else trim(Move_EmplData.Empl_Addr_Street2) I am getting this warning in Director main_program...

Thank you, that query is working

Hi, In a project i have 400 jobs, in that I have a table i.e., I08_TBL, In one of the V15_TBL we have used the I08 table as the lookup, for some reason we need to change the I08 table, how to find out all the jobs which is using I08 key and code columns in the project. Plz let me know the solution, ...

I am loading data from Dataset to Flatfile. I need convert data Decimal(17,2) as Decimal(8,2) . Sample Data 000000000002210.00 Result 002210.00 For getting above result i have to do.... If it's integer data i am doing like this Str("0",6-Len(Trim(Move_EmplData.SAL))):Move_EmplData.SAL Samp...

Thanks Guys.... I needed that syntax.

Iam not going to kill any job.

Thanks Guys.... I needed that syntax.

Iam not going to kill any job.

Thanks Guys.... I needed that syntax.

Iam not going to kill any job.

thanks for the answer

Can you plz let me know the below answer
1. how to find the process id for a particular job from UNIX command.

thanks

Hi, I know how to find the process id from Director, can you please let me know 1. how to find the process id for a particular job from UNIX command. 2. ps -ef|grep dsapi_slave|grep -v grep|grep USER_NAME Above command is used to kill a particular job which i found in dsxchange, could not understand...