Choosing right ETL tool to build new DW enviroinment
Posted: Fri Jun 06, 2014 1:18 am
Dear All,
Good Day,
We are building a datawarehouse from scratch which we don't have at the moment.
We have daily transactions of apprx 100 million records to transform and load into our new DW enviroinment.
We need to do few transformations like trimming on each field and aggregate functions before we load data into datawarehouse.
I would like to know how feasible is Datastage ETL tool to process apprx 100 million records daily using costlier transformations like Trimming and aggregating.
It would be great help if I can get some documents to read on hardware requirements and performance stats regarding the size of data that we will be dealing with.
Our source and targets are Oracle database.
Any help appreciated in picking the right choice of ETL tool, I hope I am looking at right tool and iam in right forum.
Thanks
Cherry
Good Day,
We are building a datawarehouse from scratch which we don't have at the moment.
We have daily transactions of apprx 100 million records to transform and load into our new DW enviroinment.
We need to do few transformations like trimming on each field and aggregate functions before we load data into datawarehouse.
I would like to know how feasible is Datastage ETL tool to process apprx 100 million records daily using costlier transformations like Trimming and aggregating.
It would be great help if I can get some documents to read on hardware requirements and performance stats regarding the size of data that we will be dealing with.
Our source and targets are Oracle database.
Any help appreciated in picking the right choice of ETL tool, I hope I am looking at right tool and iam in right forum.
Thanks
Cherry