Avinash,

Please look at the attached documents. First document shows step by step instructions how this is happening. Second attachement is the source file that i am using to import.

To answer your question, i am using numeric(7,4) datatype.

Please let me know if you need anything else.

Thanks

Suri