DSXchange

Dear Expert, I'm facing an issue while checking the date format in transformer stage. The date value from the input file is defined as Char[10] and the corresponding target datatype is Date. I'm checking the date format if "yyyy-mm-dd" otherwise I'm rejecting the rows. I have used the foll...

Hello Craig, Thanks a lot for your time. Actually the problem is not resolved yet. Still I face the same issue. Sorry I'm helpless. Not sure what to do. That's why I closed this post. I apologize if I made any mistake. I checked the PX manual also. As per the developer's guide document Before data b...

Hello all, In SCD Typ2 job where CDC stage is involved, I'm getting all the rows into insert and update path correctly. The issue is with the expiration date. The transformation is "In the update stream old expiration has to be updated in the target as oldExpiration_DT=DateFromDaysSince(-10,New...

Kryt0n thanks a lot for your suggestion. However, I'm not getting the desired output. I changed one column in the target table. Also for the corresponding column in the source I have included new value in the source table. One more change I made to input table is the effective date. I tried to check...

Dear experts, Now I understood, the real issue is with the join stage or funnel stage only. I tried different combinations of Join and funnel type. Join Type: (Inner, Left Outer, Right Outer and Full outer) Funnel Type: continuous, sequence and sort. I removed the join stage and funnel stage and tri...

Kryt0n and vmcburney thanks a lot for your replies. Try writing your update stream to a sequential file and see what values it has. Then run your own check to see if a record exists with such ... I tried as per your suggestion and found that I can see only new records and the old records are missing...

Bollinenik, Thanks a lot for your time and reply. Now my effective date column is loaded with correct data. However, my update DB2 stage is failing to update the Expiration date. I'm able to see the old and new data in the target table. However, the Expiration date is not getting updated as per the ...

Hello all, In one of the SCD jobs, I'm facing a new issue. I'm inserting the new version of rows and updating the previous version with expiration date value. Everything seems to be fine, except that the effective date column value is getting wrongly updated in database. Effective date column is dir...

Hello sureshreddy2009, Thanks a lot for your great suggestion. My job is working fine. :D Thanks again for your kind help. I wish to share one more point in connection with this soultion below: 1. I have deifined the required field in the Column Generator Stage. 2. In the OutPut page of this stage -...

ShaneMuir, thanks a lot for your time and reply. Actually I require these two source columns (CUST_NBR,TYP_CODE) in the middle (Links next to CDC stage) for other transformations. Therefore I'm trying to bring these two fields in the target DB2 stage (before path of CDC). Could anybody kindly correc...

Hello all, In one of my jobs the source table is defined with 27 columns and the target is defined with 25 columns. Both source and target metadata data exactly matches, except that the 2 columns (CUST_NBR,TYP_CODE) that are defined in source table are not there in the target. I'm doing a comparison...

Thanks a lot Ray. Actually I tried using a stage variable as GetDcmlVal - Varchar 20 Stage Variable Derivation: Trim(Field(lnkinpData.ProdPriceX,',',1),'"') Output link derivation: StringToDecimal(GetDcmlVal) I'm getting the expected output. :) sbass1 - for your kind information iconv /ovonv fu...

sbass1, I'm currently working on parallel jobs.

In the transformer stage use SetNull() against the corresponding null fields and in sequential stage Null Field Value should be set to '', meaning Null Field Value =''.

Regards

muralisankarr,

You can fix this by Nullable properties in the sequential file column tab. Meaning, in the column tab click on the number against the corresponding column "Edit Column Meta Data" window will open. Set the "Nullable" properties accordingly.

Regards