DSXchange

Hi Madhukar, check for below -renamed sort columns in output link of sort stagekeeping column names -check if you have set clear partition anywhere before sort stage I checked both the cases which you mentioned, it was default(clear) in orastage(which is before sort stage in my job). And the other o...

Hi igorbmartins,

I tried with that option, but no luck. It was not working and the same 3 warning messages.

any other help please.

Thanks in advance.

Hi folk, Thanks for your response. I could not find "Ordered" in the list and tried with "Round Robin" in dataset stage(target in my job) partition tab, still getting the same warning along with one more new warning like Data_Set_122: When checking operator: Operator of type &quo...

Hi All, My job design is: Orastage-->Sort-->Trf-->dataset I haev two sort keys defined in Sort stage. when I run the job, am getting warning message like: main_program: Sort key "IIMS_REF_NO" no longer exists in dataset schema. It will be dropped from the inserted sortmerge collector main_...

First you have to decide what exactly it is you want in the DATE field when it is null in the source - some kind of in-band "null" value like 12/31/9999 perhaps? ... Hi Chulett, Thanks for your quick response. I don't need that record which the Date field is having null value(or no value)...

Hi All, I have a job in which I have a DATE column which is NULL in source and NOT NULL in target. If my source value for date column is NULL, it don't want to reject that valule in trf stage. I tried with couple of functions like IsNotNull or NullToEmptyu but not working. Please provide if any funt...

Hi, My job is having the stages like this: DS -> Trf -> DS | ora stage(Rej Link) when i execute the job, getting the following error. oraCdmDefectRej,0: The system(sqlldr CONTROL=ora.29332.526144.0.ctl LOG=ora.29332.526144.0.log BAD=ora.29332.526144.0.log.bad SILENT=header PARFILE=ora.29332.526144.0...

Hi Ray, Thanks for your reply. I already created a hashed file STG_Parameters_Hash_File with all the reqired parameters, but I don't understand the other thing you have mentioned that we need to have a VOC pointer to it. Can you please tell me how to get or define that VOC ponter? Thanks in advance ...

Hi saikir, The Below mentioned code illustrates how to read the following parameters from a parameter hashed file and log information about the directory paths in the log: I have written the query given by you in Job control and added one job in the same job control of batchjob at the end of the cod...

Thanks a lot Ray.

You are correct my script exits with status of 1. I will change it as 0 and run the job again. If change 1 as 0, will it impact on script?

Thank you once again.

The job got aborted even I changed the command as . /u6/app/datastage751/dwhsetld/invoice/scripts/stg_invdisct_ods_load_uanz.sh The error message I got is 22:17:33: Execute_UANZ (COMMAND . /u6/app/datastage751/dwhsetld/invoice/scripts/stg_invdisct_ods_load_uanz.sh) started 22:17:33: Execute_UANZ fin...

Hi Ray/Hulett, Thanks for your reply. The job got aborted even I changed the command as . /u6/app/datastage751/dwhsetld/invoice/scripts/stg_invdisct_ods_load_uanz.sh) The error message I got is 22:17:33: Execute_UANZ (COMMAND . /u6/app/datastage751/dwhsetld/invoice/scripts/stg_invdisct_ods_load_uanz...

Hi, I want to run the Unix shell script using Execute Command Activity in Sequence job. I have given the command in Command box like sh -c ". /u6/app/datastage751/dwhsetld/invoice/scripts/stg_invdisct_ods_load_uanz.sh" But Seq job got aborted. My question is: Is that command incorrect? or ...

Thanks Craig,

I could find the where the problem is by setting the Array size to 1.

There is a NULL value trying to load into the Not Null column.

Thanks alot..

Hi,

I would like to add one more point here. The same job when I ran in the older version i.e. V6.0, its running fine without any warnings. Only the problem is in new version V7.5.1a