ETL( Extract Transform Load)

Question

Hello Friends Today i have a bit of difficult problem. I have to code an ETL tool. Which will basically Extract data from a database file. Then after extraction i have to perform certain Transformation on that data to bring it into standardized format. The main task is to transform data. Can please you people suggest me the logic that i should perform to accomplish the task. The described statement file is attached below. Regards Zeb

Rafeeq Mohamed · Answer

Hi Zeb You can achieve this many ways if your project is estimated for BI (SSIS) you can easily do this with SSIS including some custom scripts. Reference: http://msdn.microsoft.com/en-us/library/ms169917.aspx Or you want to meet this requirement with C# You can use LINQ to perform the same also look below tools. http://fluentetl.codeplex.com/ http://ayende.com/blog/3102/rhino-etl-2-0