DSXchange

Thank you and I used the Downcase () and Upcase () and resolved this problem.

Thank you. I have used the below expression and the problem is resolved. if Biseps_Genericcode.BISEPS_GENERICCODE = hash_Biseps_Genericcode.AB_CODE AND not(isnull(hash_Biseps_Genericcode.AB_SUBGROUP)) then hash_Biseps_Genericcode.AB_GROUP:" ": hash_Biseps_Genericcode.AB_SUBGROUP else if Bi...

I am doing concatenation of two column values if below condition is true AB_GROUP has the value - 'switch' AB_SUBGROUP has the value - NULL or empty Condition if Biseps_Genericcode.BISEPS_GENERICCODE = hash_Biseps_Genericcode.AB_CODE then hash_Biseps_Genericcode.AB_GROUP:" ":hash_Biseps_Ge...

What I did now is before concatenation with SMD , I checked for the field B is having 'SMD' or 'smd' using the expression below like if column B = 1 AND LEFT(column A value,1,3) <>'smd' then "SMD ":Column A value else Column A value The above command is checking for 'smd' alone. Is there a...

I did the concatenation and got the result as

'SMD smd 14 pin'

From this above result, I need to remove the 2nd 'smd' as it is repeating twice and final output should be 'SMD 14 pin'.

There are 2 input columns A & B where the values will be like below Column A has values like smd 14 pin SMD 16 PIN SMD SOT-23 Column B has values like 1 1 1 1 Output column C =Populate the values 'if the column B =1, then concatenate"SMD": column A values' The result is SMD smd 14 pin ...

Thanks, Ray. This problem is resolved and I used the below in transformer stage to avoid the warnings and filter out null records.

Not(IsNull(lookup_BISEPS_MODELNUM.BISEPS_MODELNUM))

I am creating a hash file from db2 table for the purpose of lookup. In db2 the column 'biseps_modelnum' has both null values and values. This biseps_model num is the key for the lookup. When I am running the job, I am getting this below warning as null records are there. How to avoid this warning? S...

The purpose is for the business wants to see the rejected records and to know the reason why it got rejected and for the reconcilation purpose.

I have 3 different lookups and these 3 lookups have rejections and exceptions. Which is the best method to design the error table? Either to have separate error table for each lookup with the key field, error no,error code, and error description or to have a common error table so that it can be refe...

I am getting the below warning when running my validate and load job. How to avoid this below warning?

BISEPS_MODULEITEMS_ASSET_LOAD..od_ASSET: This update action 'insert or update' is not compatible with parameter array binding. Array Size property will be set to 1.

I have used the Hash file and removed the duplicates.
Thank you very much

This issue is resolved by writing the if command

Thanks , Ray. The problem is resolved.

As mentioned by you, I used the constraint expressions like below

Constraint expressions.
InLink.AS_LOCATION <> "D" (regular output)
InLink.AS_LOCATION = "D" (reject link)

Thanks, Chulett. Like you told,I used one 'IF' and 'AND' like below and it is working fine. if Mark_D.AS_LOCATION <> "111" AND Mark_D.AS_LOCATION <> "112" AND Mark_D.AS_LOCATION <> "105" AND Mark_D.AS_LOCATION <> "104" AND Mark_D.AS_LOCATION <> "108"...