After column analysis done , for some tables i am geting the error like this "The requested Data Is Empty:" when i am going to view the sample data even though data is exists in the oracle db .
Only table structures are imported, and then they're largely ignored while the analyses look at actual data (what's really there, as opposed to what the metadata claim).
Usually the sample is created during the Column Analysis phase. Can you review your work there - even reset so that the Column Analysis is recorded as not done - and check to see whether you disabled generation of the sample data? What sample size did you specify?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.