DSXchange

Should use : Given in below

Column SQL Type
Date VarChar


I believe it will work.

For date dimension, should write Procedure along with require attribute as per the business requirement. When you compile the job corresponding data will fetch form your database at run time.

Before run the job, Should check all permission are granted for file and Folder at UNIX level.


/tmp folder has all 777 rights (owner is dsadm).

Should use transform stage in between flat file and filter stage and use below syntax.


Product_ID : If IsNull(product_id) then setNull() else trim(product_id)