DSXchange

Thanks a lot kumar i am not getting those warnings now.

u need to cleanup ur scratch space ,keep monitoring the scratch space whenever its getting over the limit of ur actual memory clean it up.
as kumar said u can find a bunch of post on this forum discussed on scratch space.

Hi All i am running a parallel job which contain the stages like transformer ,CDC, join, lookup and sort .my source is seq file and target is SQL server .i am getting these 3 types of warning can any one plz help me how to get rid of these warnings Join_479: When checking operator: User inserted sor...

Hi All i am running a parallel job my source is a seq file and target is SQL server ,job is running fine but its giving bunch of fatal errors as SQLServer_Enterprise_403,1: [Microsoft][ODBC SQL Server Driver]Communication link failure [Microsoft][ODBC SQL Server Driver]Communication link failure can...

u can use RCP(run time column propagation)

set the key value and also set the change mode option in change capture as Explicit keys,All values and try hope this will help u

try using join instead of lookup stage

u might need to install the C++ compiler

Hi All
i am running a job which has two seq files 1 and 2 passing through CDC and the output file is pathed same as seq file 1 its working fine but i want to knw is it the right way will it be a problem later like deadlock or something.any suggestions will be appreciated

hi i tried running it manually outside data stage job it is working i tried to move 10 million rows in an empty file

yes i used move its still not working

i tried mv while testing with small data it worked fine now im running with full file and these 4 files have around 30 million of records . i am trying to create 4 master files in one job is it a matter with memory

when i run it maually its not moving the file but the code looks fine mv F:\CURR_MASTER_FILES\iro_Claim_NEWMSTR.txt F:\CURR_MASTER_FILES\iro_Claim_MSTR.txt mv F:\CURR_MASTER_FILES\iro_ClaimHold_NEWMSTR.txt F:\CURR_MASTER_FILES\iro_ClaimHold_MSTR.txt mv F:\CURR_MASTER_FILES\iro_Order_NEWMSTR.txt F:\C...

Hi All i am running a parallel job which has two input files master and chg passong through CDC results a new master which shud b moved to input master so i am using after job sub routine ExecDOS initial value = path of a bat file which has move command . when i run the job job is running fine but r...

i tried Null Field value = ' ' but still it is giving this warning .My file is a pipe delimited why it is giving warning as fixed width i dont knw.