I am not directly importing table. I am uisng a SQL like

Select * from Dimtable

where pk_id (select pk_id from factable where period between 20130101 and 20130131)

I am not importing as a table since I want the for particual period.

My fact table will be

select * from factable where period between 20130101 and 20130131

once imported, I went to pk_id columns and went to properties, I set up datatype and data format as whole numbers.

Interesting part is some times when I do like above, its coverting to unique numbers. Some times its not coverting as unique numbers.

I have no idea on how to fix it up.