DSXchange

thnx for the reply ...

is there any other way that I can convert it to decimal (10,3) ?

I am reading it from sql server tbable as float and inserting it into the sql server table .

It is SQL database and dataype is float

some of the values in column are coming as 1.00088e+06 I want it to convert it in a number/numeric format . so can I do this ?

job is

odbc stage --->transfrmer----->odbc stage

In my job s there are more 25 columns for which I am getting this warning message so how do I supposed to use message handler?

Hi In one of the jobs where I am just fetching some data from oracle table and inserting/updating it to sql server table. But whenever I run the job it just remain in running condition only and nothing happens. it it is not pulling data from oracle also. The last message in log I can see is main_pro...

Hi In my job I am extracting data from oracle tables and inserting it into sql server tables. I am getting following warning messages .. any idea how to resolved it ? Oracle_Enterprise_5,0: Column POUNDS floating point decimal is not fully supported; adjusting the scale. [orautils.C:2383] Thanx in a...

Hi While trying loading data from oracle table to sql server tables jobs are failing with fatal error : APT_CombinedOperatorController,0: [DataDirect][ODBC lib] Program type out of range [odbcUtils.C:277] DataDirect][ODBC SQL Server Driver]COUNT field incorrect [odbcUtils.C:657] any idea how I can r...

keshav0307 wrote:In the source table the column type is decimal[28,0],
whereas in the OEE stage, the coulmn is defined as Integer.

in source oracle table data type is number in datastage in destination we are ref. it as integer ...

HI My job is like oracle enterprise stage ----->Transformer------->ODBC stage. Source database is Oracle Destination database is SQL server. My jobs are getting aborted with following warning message : (mentioning just one for eg. there are 50 such column gvng same error) Oracle_Enterprise_5: When c...

HI Parallel job getting aborted with error Parallel job reports failure (code 139) Contents of phantom output file => RT_SC8832/OshExecuter.sh[20]: 1978564 Segmentation fault Job design is oracle stage ----> transformer----->lookup------>transfprmer----->oracle stage Any suggestion how can i resolve...

ok got it ... i need to monitor

sufficient scratchdisks in either the default or "buffer" pools

which space I need to monitor
where file is getting created
or

resource disk "/data01/Datasets" {pools ""}

or

resource scratchdisk "/data01/Scratch" {pools ""}

{ node "node1" { fastname "natsci163" pools "" resource disk "/data01/Datasets" {pools ""} resource scratchdisk "/data01/Scratch" {pools ""} } node "node2" { fastname "natsci163" pools "" resource dis...

Hi All One of the parallel job gettign qbporetd with the following error : buffer(5),3: APT_BufferOperator: Add block to queue failed. This means that your buffer filesystems all ran out of file space, or that some other system error occurred. Please ensure that you have sufficient scratchdisks in e...