DSXchange

Hi,

How to convert 60 digit Alpha Numeric value to 40 digit?

My Source is 60 digit Alpha Numeric value but my target has 40 digit alpha numeric. How to convert 60 to 40 digit Alpha numeric value??

Hi Ray,

I am not a Premium Member(shortly I will be a premium member).I am not able to see entire message. Can you please copy the routine.

I am trying to execute the below data stage server routine to get the link count of the source and target but I am getting warning-7 please let me know if i miss any thing in the below routine $INCLUDE DSINCLUDE JOBCONTROL.H JobHandle = DSJ.ME JB_HANDLE = DSAttachJob("jobName",DSJ.ERRWARN)...

masterControl table .Below are the fileds of the table MasterProcess Identifier Process Start timestamp Process End timestamp Process Control Status Code Valuation date Fixed variable indicator Lastupdate time stamp Please let me know how to update the control table fields . I need to capture each t...

Hi All, Please let me know whether this left outer join is correct? If correct will it effect the performance because I am using join with more than one columns. both tables are in database so can I use the SQL join or data stage join. left table contain millions of records. SELECT a.contractno, b.p...

Hi All,

How to populate the Audit table in data stage. Is there any Routine for that .Each time When the record is rejected I need to increment the count in the audit table along with this i need to calculate Amounts and load into Audit tables?

We suggested to client changecapture stage.But client are interested on checksum stage...

In page 155 I read but not clear.
http://www.redbooks.ibm.com/redbooks/pdfs/sg247830.pdf

Hi Ray, I need to use checksum stage only. Below is my example Input ------ e_id,e_name,e_Add 11,kim,bris 22,jim,mel 33,pim,syd 44,lim,canb 55,pom,pth Output Before_Loading ----------- e_id,e_name,e_add 11,kim,syd 22,jim,canb 33,pim,syd 44,lim,canb 55,pom,pth Out After_Loading ----------- e_id,e_nam...

Please let me know how to use the checksum stage.my requirement is to compare the source and target and if any new record found or any value updated then load the data into the target table.

Hi Prasoon,


I need to load the target table with only the new records I mean incremental load.I don't want to load every time the same records from source to target.If the new record or any updated record I need to load.Please let me know how to use the checksum stage

My Source is file and target is table.I need to compare a table records with records in a file to see if any field has changed. I am not sure if I should calculate the checksum then do the comparison. Please let me know how to use check sum stage.
Thank you in advance.

Hi Chulett,

My source data types are varchar and target is two fields. my first datatype will be timestamp and second will be varchar and no space between
month and year...

Hi All, I have input is Date,Time_Posted ------------------ 8th November2013,12.30 midnight 21th July2013,8.30pm 13th December2013,8.00pm 9th May2013,12.30 midnight 11th April2013,12.30 midnight. I want output as ----------------------- Date,Time_Posted 8-11-2013,12.30 midnight 21-07-2013,8.30pm 13-...

Hi,

I have source is

sno,sname
1,x
1,y
2,y
2,z
3,z

I want target is

sno,sname
1,z
2,x
3,x
3,y

Could you please explain me?