Thanks for the reply.

I changed the datatype to Whole number and data format to whole Number.

It processed again and coverted the column to Number format but now we are getting same number for two or more diffrent records which is causing duplicates error when we establish join between fact and dim.

when I went to Toad and check for any duplicates in Dim table, I dont see any duplicates.