DSXchange

Thanks for your responses............

Hi, I am interested in getting the CPU time taken by a job to complete. In the Director log I could see Start up time & Production run time as follows. main_program: Startup time, 0:11; production run time, 4:04:20. Could somebody please let me know What do these time (start up time and Producti...

Hi, We have a fixed length sequential file. In sequential file stage ,we are trying to make one Nullable numeric field Numeric(11) as NULL, if the input field has value 99999999999. In the column properties we are giving the Null field value as 99999999999. But it is throwing warnings. Please sugges...

When I am running a query like : SELECT TO_TIMESTAMP(LAST_DAY(ADD_MONTHS(SYSDATE,-1))) LOAD_DT, 'ACCT_PERFM_ANLYS' TARG_TBL_NAME FROM DUAL the query is failing. It throws error like Internal Error: (colDesc):orautils.C: 1714: getColDesc failed The query is working fine in the oracle prompt. Please t...

Hi,

Thanks a lot for the response.
I tried the query you sent . But still I am getting the same warning.
Could you please suggest me ssome more options??

Thanks
Archana

Hi , We have got a column(addr_key) in the oracle table which has metadata like Number(11). In the datastage job , we have a query like SELECT MAX(ADDR_KEY) ADDR_KEY , 'ADDR_DIM' TABLE_NAME FROM ADDR_DIM While running the job we are getting following warning. oraAddrDimsel: Column ADDR_KEY floating ...

Hi , We are getting following warning in oracle stage. oraAcctStatDimsel: When checking operator: When binding output interface field "ACCT_STAT_KEY" to field "ACCT_STAT_KEY": Implicit conversion from source type "decimal[38,10]" to result type "decimal[11,0]"...

Hi , How do we get the number of warnings in the current run of the job ? We tried with dsjob -logsum -type WARNING <project> <job> | grep -c WARNING It gives no of warnings in the whole lot of jobs present in the director. We want the number of warnings in the log of the current job ran .

Hi, How can we get the number of warnings , recieved while running the datastage job in PX . While running the job using script the option -warn 50 limits the number of warnings after which the job should abort . In the UNIX script which runs the job , How do we get the exact number of warnings enco...

Hi, We are trying to run the datastage job using script on UNIX. We are passing parameters used in DS jobs thru the script. param $prmDirLanding=/data/ds/ccs/dev/xcamp/landing -warn 1 -jobstatus dpr_ccs_dev djpCpySeqToDatasetstest + /opt/tools/ds/Ascential/DataStage/DSEngine/bin/dsjob -run -mode NOR...

If you have single input sequential file as an input in one of the server jobs and you have got to insert and update a table .

I want to insert the keys if the keys are not present in the table and also update other columns(other than keys) from the input file fo the inserted keys. Can I do it ?

Archana, a hashed file key is unique. If you specified all 3 key columns when you wrote to the hashed file you cannot have duplicates. Are you certain you specified all 3 columns as keys for the hashed file? If you are certain, could you show an example of a duplicate record? Hi Archana, I also had...

kumar_s wrote:Keys in the hash file cannot have duplicates.
Are the records shown are from Hash file?
What is the datatype of the key fields?

Ya the records are from hashed file .
The datatype is varchar for all the fields.

Archana, a hashed file key is unique. If you specified all 3 key columns when you wrote to the hashed file you cannot have duplicates. Are you certain you specified all 3 columns as keys for the hashed file? If you are certain, could you show an example of a duplicate record? Ys , I have specified ...

Hi , I am trying to dedup a sequential file on some keys (combination of 3 keys) . The output is a hashed file with those three fields as keys . But the files ia not getting deduped , I am finding records with dupliacate values of those keys . The parameters and all sre fine in hash file . Please , ...