DSXchange

Yeah..Kumar .I am getting from source as Char(6):123456 but when I am trying to load into Target as Dec(18) using StringToDecimal Function it is getting loaded as 0000000000000000.00. if I change the datatype as Dec(6) the data is loading as space12345. The last digit 6 is getting trunacting.Please...

ArndW wrote:Does it hang if you use a 1-node configuration file? ...

Yep. It hangs when 1-node config file is used.

Does it always hang, does it hang if you write to /dev/null on a text file? Does it hang if you generate sample data with a row generator stage?

Row Generator stage works to write to Flat file . Job hangs only when wrting to Oracle.

This is a duplicate thread of :viewtopic.php?p=302816#302816.

Jones,Please delete /unamrk any one of it, hence there won't be any confusion.

Thanks,

The Job hangs only when I try to write to Oracle. Flat file stages are working fine.

@Istsaur
Oracle is on Hard Drive E: & DS on D:
Drive D is formatted as NTFS file system & all other as FAT32.
Does the problem lies here??

Thanx for pointing me. Yes, I am writing it Directly to Oracle. I followed the below sequence:- 1.Used "Reset Job" option in Director. Waited for 30 min. No use.The Job status is displayed "Running". 2. Then I used "Clean Up Resources". No Use.The Job status is still di...

Starting Job test_1. Environment variable settings: ALLUSERSPROFILE=C:\Documents and Settings\All Users APT_AUTO_TRANSPORT_BLOCK_SIZE=1 APT_CONFIG_FILE=D:\Ascential\DataStage\Configurations\default.apt APT_DUMP_SCORE=1 APT_OPERATOR_REGISTRY_PATH=D:\Ascential\DataStage\Projects\development\buildop;%...

To apply CDC u need 2 Lookup to check for Non-key field value changes.
Include a Lookup between Stg_table & Transformer.