DSXchange

The requirement is this. I have 2 columns -AS_LOCATION & BISEPS_MI_AD_ID 1) IF the incoming records has the value of AS_LOCATION='FA' and BISEPS_MI_AD_ID=90002 then the output column AS_LOCATION should have the value of 101 2)IF the incoming records has the value of AS_LOCATION='FA' and BISEPS_M...

The requirement is this. I have 2 columns -AS_LOCATION & BISEPS_MI_AD_ID 1) IF the incoming records has the value of AS_LOCATION='FA' and BISEPS_MI_AD_ID=90002 then the output column AS_LOCATION should have the value of 101 2)IF the incoming records has the value of AS_LOCATION='FA' and BISEPS_M...

I have tried the 2 options, but still it is throwing me error. Can you plz help me out. I don't know where I am doing the mistake. option-1 if Reject_link.AS_LOCATION <> "111" else if Reject_link.AS_LOCATION <> "112" else if Reject_link.AS_LOCATION <> "105" else if Reje...

I am getting error while writing the query in transformer. The purpose is to mark the record as "D" which are obeying this condition if Transform.AS_LOCATION <> "111" if Transform.AS_LOCATION <> "112" OR if Transform.AS_LOCATION <> "105" OR if Transform.AS_LOC...

I have a column "AS_LOCATION' which has value of 101,111,105 and D. I need to reject the records with value 'D' and populate the rest into target table.

Please advise.

input field has field of values "as_location"( VALUES,-SI, FA,FP) and "biseps_Md_ad_id"( 90002, 78582, OTHERS) which has to be lookup with MI_STATUS(VALUES LIKE SI, FA, FP) & MI_AD_ID(Values -90002, 78582, OTHERS) TFM N logic is 'if Mi_status=fa and mi_ad_id=90002 then 105 to...

How to remove the duplicate records in Datastage server edition jobs? Which stage I need to use? Is there any stage like 'remove duplicates' like in parallel extender?

Thanks. I am able to create a output file with file name and input date. How to generate the output file with the filename_jobrunning date?

Thanks, Ray. The issue is resolved as the permission is granted to update , insert the table.

I am getting the below error in DS director while trying to load the data into (T_LOCATION )DB2 table. Please advise

DBMS.CODE=-668, SQLSTATE=57016, [IBM][CLI Driver][DB2/AIX64] SQL0668N Operation not allowed for reason code "7" on table "SCTMIG_DEV.T_LOCATION". SQLSTATE=57016

How to create a output file with a name MAXIMO_ITEMS_YYYYMMDD.dat when the input file is in the format of BISEPS_MT_YYYYMMDDHHMMSS.dat.

Shall I pass MAXIMO_ITEMS & YYYYMMDD as separate parameter in job? which is the best way?

when I am writing the input value of 'MI_SUBMODULEOF' into a hash file ( direct mapping) thru transformer stage, the value 'zero' is getting populated in output without any warnings in director.

Please advise

I am mapping the input field 'MI_SUBMODULEOF' which is integer from seq file to DB2 TABLE of field 'MI_SUBMODULEOF' thru transformer stage of datatype integer ( Direct mapping ). The input field has a value of zero and when it get populated to DB2 , it is null and throwing the below warning in seque...

Yes. I am giving the input file name in the job parameter as 'BISEPS_MT_*20080730*' but the output file should have header as
Line 1- 'BISEPS|BISEPS_ITEM_ES
Line 2- all the column headings

how to do this?

How to add a file name to Header for the output sequential file with delimited as pipe (|)