Loading

ETL( Extract Transform Load)

Zeb Rehman

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rafeeq Mohamed14y ago
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