DSXchange

HI I have target FCT_JOB_EQUIPMENT WITH COULUM REC_TYPE THE STABLE IS SOURCED OUT OUT OF THREE 1)STG_JOB_EQUIPMENT2)STG_CUST_RETURN3)STG_JOB_RETURN IF THE SOURCE IS STG_JOB_SHIPMENT THEN INSERT "SHIPPED EQUIPMENT" IF THE SOURCE IS STG_CUST_RETURN THEN INSERT RETURNED BY CUSTOMER IF THE SOU...

HI,
i have source varchar2(20) like HS2002156817161-1 AND MY TARGET IS
Number(20)(fk) it should be 2002156817161-1 how can i do ir and my target is fk is that conversation possible. pl advise.
Thanks,
Bobby

HI, I AM GETTING THIS ERROR DIMFWFMJOB..Transformer_4: ORA-01722: invalid number DIMFWFMJOB..Transformer_4: The value of the row is: JOB_ID = NINI JOB_INSTALLER_KEY = 3204 ETL_CONTROL_KEY = 1165 SSWAT_ORDER_KEY = 223823 ORDER_ID = HS2004129320511-1 COMPANY_ID = ETS-EST OMC_ORDER_ID = OMC64628 CUST_N...

hi actually the source is 3133456784
will the same field work there too
thanks
bob

Hi Chuck
when i am writing my original id to hash file as some rows are blank ---
so its giving me error HSHSWWATORDER..Hashed_File_1.DSLink2: ds_uvput() - Write failed for record id '<Missing or NULL>' as i am making orginal id as primary key in hash so should i ignore that error
Thanks,
bobby

hi, can u please guide me i have in my source order id previous_orderid original_order_id 51411 - - 51428 51411 51411 51432 51411 51411 this record comes as 1 record i want my curr_flg be 1 on last order id thats 51432 please guide me i am in fix do i have to write some kind of subquery Thanxs bobby

Hi Chulett, l am doing like this i have table aa columns aa1(pk) aa2, aa3 from my generated sql i copy and paste to user define sql and make aa1 as surrogated key same as u said aa1.nextval in user define sql, NOW WHEN I COMPILE AND RUN LETS SAY SAME JOB i have 10 rows when i compile first i saw 10 ...

Hi frnds, i am dealing with TYPE 2 dimension however it does not follow standard type 2 dimensional due to fact the business key keeps changing and source system maintains rolling history in 3 columns orderid previousorderid originalorderid i mean if order id is 1 2 3 previousid - 1 2 originalid - 1...

HI, i have a source staging and DM My req are like this in DIM_JOB STG_JOB Cust_phone cust_phone ptn_area_cd parse cust_phone -1st three chracter area cde ptn_npa parse cust_phone three chracter starting at 4th digit and insert first 3 chracter of phone no. ptn_npa_nxx parse cust_phone-last 4 chract...

hi, i am using SCD type 1 , Everytime we insert new data ,i am using surrogated keys user define sql , i have few question , i wanna insert new data so that prvious data be overwritten everytime i write a data , i have created seq in oracle so evrytime i truncate table and load data , sql set to use...

HI THERE
I have to handle type 2 dimension in dim table can u let me know how datastage handle it
thanxs
samra