DSXchange

hi, I have a Hash file with enbaled cache write from source for delta when i was trying to compare on order id like 3 rows cannot be compared and job finish with this error, CopyOfDIMSSWATORDER..Transformer_4: ORA-01400: cannot insert NULL into ("DWADMIN"."DIM_SSWAT_ORDER"."...

Hi,
its date type format
Thanks,
Bobby

Hi frnds, I am getting this error i have hard code my effective date in Transformer '2500-01-01 00:00:00' as i am trying to convert this effective date with the end date i saw this error ,My end date is in DSJOBSTARTdate when i am using IF DSLink10.DIM_FWFM_JOB_KEY <> DSLink4.DIM_FWFM_JOB_KEY then D...

Hi,
I was writing a hash file for delta the number of rows are like 1,459,394
and its adding 3200/day, My allow stage cache create file is marked ,
i was wondering whts max number of records hash file can have .
Plz advice.
Thanxs
Bobby

hi, i am using compare of columns for finding delta ,like if linka<>hashlinkb then linka else hashlinkb and applying constriant on hashfilenotfound Now I have some problems 1) still duplicates rows do pass 2)error comes like hash file is null. (hash file is from same target ,if load is incremented h...

Hi Ray,
Can this things be disccussed private budy

hi,
stg is in varchar it need conversation in date in Datamart ,pl. advice.
Thanks,
Bobby

Ereplace(Oconv(DSLink9.EFF_DT["2500-01-01 00:00:00.000"],"DYMD[4,2,2]")," ","-"):Oconv(DSLink9.EFF_DT["2500-01-01 00:00:00.000"],"MTHS")

Still not working plz guide

hi,
i have my date in DSJOBSTARTDATE
dslink2.effdate i was trying dslink2.effdate["2500-01-01 00:00:00.000"]

its giving me blank plz advice abt how i can trnasform it too


"2500-01-01 00:00:00.000"
Thanks
Bobby

hi, i am sturggling with delta stuff i read crc example too , i was looking at compare (string1,string2[,justification]) syntax i have source string1 and hash file from staging string 2 i said compare(string1,string2 ) what justifaction shoule be done so that delts can be read ,pl advice i will be o...

hI,
i have adress_id in source and mapped to staging adress_id ,now if u want to increment to adress_id (its unique ) how can i do it, if any example like compare can be given it will be help.
Thanks,
Bobby

HI , I AM SENDING ONE SAMPLE FRP INCREMENT LAOD IS IT OK PL. GUIDE SELECT ATS_ACTIVATION.ACCT_NO, ATS_ACTIVATION.CONVERTER_SERIAL_NO, ATS_ACTIVATION.RECEIVER_TYPE_ID, ATS_ACTIVATION.ACTIVATION_TYPE_ID, TO_CHAR(ATS_ACTIVATION.ACTIVATION_DTE,'YYYY-MM-DD HH24:MI:SS'), TO_CHAR(ATS_ACTIVATION.CREATED_DTE...

Hi,
SO i guess crc32 will help in delta capture ???
Thanks,
Bobby

Hi ,
I am using oracle 8 for as source and target plugin to import data ,CDC
do we have option in oracle 8 or in datastage 6 server too.please advise if we have the option how can i find it.
Thanks,
bobby

hi,
i want to incremental procedure from my sourceto staging , ahat best ways are there i know onw max timestamp but some source have no timestamp thing,plz advice.(datastage 6 have any unique feature my source and target are ora
Thanks
Bobby