DSXchange

i have a job which was stopped via director when i am compling it
its saying job being mointered if i make copy of it and try to delete it
will it help 2) why that error is coming (as i am only accessing that job)
thanks
bobby

hi,
just a clarifaction if i reboot the datastage server will it take care of
locked jobs ? or i have to still kill them ?
thanks
bobby

other jobs do hang too will rebot server help

Hi,
i am trying to update a job earlier it usually takes 10 minutes to update
but today its hanging like on 25000 rows giving 25000 rows 40rows/sec
but its not moving from 25000 (total number of count is 27610) ,
As it was running good for 1 week , Plz suggest.
Thanks
Bobby

hi,
well my frnd BY MAX I MEAN i have same max(order_id) in source
and staging but its come less by 3 in development. i am using inter process should i use default i mean 3 rows miss
Thanks
Bobby

dear frnds, i am looking for deltas from source to staging (delta is looked via max(order_id)) where V_ORDERS.ORDER_ID> (SELECT (MAX(ETL_CONTROL_TABLE_LOAD.MAX_ROW_ID)) FROM E_EXPRESS.ETL_CONTROL_TABLE_LOAD WHERE ETL_CONTROL_TABLE_LOAD.TABLE_NAME = 'STG_SSWAT_ORDER') its ok, i am applying same logic...

Hi Duke,
so index on table in oracle,
Thanks
Bobby

Hi, I have a hash file omc_order_id and i am joining it with the order_id of my table which has to be updated i make omc_order_id as key joined hash file omc_order_id with order_id and then just updating ni_work_key like this IF DSLink4.ORDER_ID=hashfile.OMC_ORDER_ID then hashfile.NI_WORK_KEY else '...

hi,
i am trying to update on a single column
UPDATE DWADMIN.DIM_SSWAT_ORDER SET NI_WORK_KEY=:1
this table has about 500,000 rows its taking for ever
plz guide.
Thanks
Bobby

hi, i am trying to update a dimensional table from dim table(star flake) i have (user define query for sql in my datastgae job in oracle 8)i was trying to update only on 1 column my surrogated from dim table(based on business key), its taking too long 1)i did it my making new job 2) and (writing sam...

Hi ,
Thats exactly is did , but same error when i look hash file CRC32 have
created values too.
Thanks,
Bobby

hi,
I just download CRC example and was trying to implement in my Job,
i have an error in CRC variable not define but the job which i load its not showing any error
CRC <> lkup_hashfile.CRC or IsNull( lkup_CRC.CRC)
by
plz advice.
Thanks
Bob

HI, I am having hash file which is populated from my source (first increment) the hash file i am populating on column its not null ( like 20 rows from source 20 rows to hash file )(hash file write cache enabled) step 2 ) same hash file then i am linking to transformer for finding delta its giving th...

source --------transformation---------target
---------hash file
first i am populating the hash file with order id and then use same hash file for finding delta .
Thanks
Bobby [/u][/quote][/code]

My sql says no null on order_id

SQL> select order_id from dim_sswat_order
2 where order_id is null;

no rows selected

One thing more when u say constriant is the format of constriant like this
DSLinkhashfile.NOTNULL
Please suggest
Thanks
Bobby