sumeshabraham
Programmer
Hi All,
I worked on a multple technology project which had 2-3 modules which used DataStage as ETL tool.The project as a whole was not a Data Warehousing project. So I'd no practical exposure to Facts, Dimensions,Schemas(Only theoritical knowledge) ...etc. I was using the ETL tool for meeting the requirements. Recently when I faced an Interview, the interviewer was interested in asking only the DW designing and he never asked anything about the tool and his opinion was that a guy who is very good know-how of the practical things of DW can get on with any ETL. I couldn't clear it eventhough I was very confident in the tool.
I would appreciate if you can give me suggestions on how to overcome this problem, the main areas to focus in the practical side of DW (Before ETL comes into picture)and please tell me briefly the steps in a typical DW project?
Thanks a lot,
Sumesh
I worked on a multple technology project which had 2-3 modules which used DataStage as ETL tool.The project as a whole was not a Data Warehousing project. So I'd no practical exposure to Facts, Dimensions,Schemas(Only theoritical knowledge) ...etc. I was using the ETL tool for meeting the requirements. Recently when I faced an Interview, the interviewer was interested in asking only the DW designing and he never asked anything about the tool and his opinion was that a guy who is very good know-how of the practical things of DW can get on with any ETL. I couldn't clear it eventhough I was very confident in the tool.
I would appreciate if you can give me suggestions on how to overcome this problem, the main areas to focus in the practical side of DW (Before ETL comes into picture)and please tell me briefly the steps in a typical DW project?
Thanks a lot,
Sumesh