can any pne xplain the importance of adapter and transformer and what are the differences between adapter and a transformer .

You should spend some quality time with the IS Developer’s Guide and JDBC Adapter User’s Guide. Once you’ve done that please feel free to post specific, detailed questions that demonstrate that you have invested some of your own time and effort into learning the answer. If can do that, you’ll find the user community here very willing to help. If you don’t want to invest effort to learn on your own, why should the community spend any time helping you?

See the “How to Get Help at wMUsers?” sticky post for more ideas of asking questions that will get answered quickly.

Mark