How and where to start ODI
How and where to start ODI:
Today you wont get that much excitement as I am not going to write anything new. The reason being I have got so many mails from people, those are new to ODI World, specifically those are coming from testing background or people from outside Data Warehouse world that they do not have much insight about ODI. How to use where to use and when to use. I feel happy that they are very open and do not hesitate to ask even silly question though they are experienced. Today I will try my best to give you some heads up to get you started. If you know any of the below step then you can jump to the next one. Dont expect you will get everything in one day just by reading. Patience and practice makes you perfect.
#1. Make sure you know what is data warehouse and different types of system. Always remember the 1st image in this link.
#2. What is ETL and what are the ETL tools available in market.
#3. What are the reporting tools available in market.
#4. What is the different between ETL and ELT
#5. Make sure you know any of the RDBMS. For example Oracle.
#6.Introduction to ODI.
#7. JDK is an important part of ODI.
#8.Downloading and Installing ODI
#9. What is repository in ODI and its types.
#10.Creating repositories for ODI
#11. Load data from table to table in ODI
#12. Visit again #6 to recall about TOPOLOGY, DATA SERVER, PHYSICAL SCHEMA, LOGICAL SCHEMA, DESIGNER, INTERFACE, KNOWLEDGE MODULE, OPERATOR, SECURITY
#13.Load from table to flat file in ODI
#14. Load data from flat file to table in ODI
#15. Load data from flat file to flat file in ODI
Thats it. If you have completed all the steps in your system then congratulation!! 🙂 . You are ready to start with advance stuff in ODI. It wont make you a master but enough to get you started with ODI. Need instant help if you are stuck?? No Problem. Here is the OTN Forum link where you can post your questions. Last but not the least I am always here to help you out.