if i am connected with oracle DB and want to load table from oracle DB , can we transform the data that are coming from tables.
Yes, you can.
Please read these two documents:
First of all your asking the question without full details.
You can load the data from DB tables and then store the these tables into QVD's. After that you can apply transformation on raw QVD's.
Retrieving data ...