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