Hardware config

krisna · Post by **krisna** » Wed Mar 31, 2010 12:09 am

Hi,

Source data is having 5 TB of data.

What should be my server hardware config.

OS : 2003 server, I need other details.

Thanks in Advance

ArndW · Post by **ArndW** » Wed Mar 31, 2010 2:21 am

5TB of source data transferred through DataStage with no modification or conversion can be done on a notebook. More complex transfers cannot.

We need other details.

krisna · Post by **krisna** » Wed Mar 31, 2010 5:48 pm

We have transformation rules also.

what I want to know is about the Hardware configuration and that server concurrently should be accessed by 20 developers and all the 20 developers will be using 5TB of data and also applies some transformation rules.

krisna · Post by **krisna** » Wed Mar 31, 2010 5:50 pm

We have transformation rules also.

what I want to know is about the Hardware configuration and that server concurrently should be accessed by 20 developers and all the 20 developers will be using 5TB of data and also applies some transformation rules.

sources are sequential files and target is oracle

ray.wurlod · Post by **ray.wurlod** » Wed Mar 31, 2010 6:50 pm

We still have no idea of the complexity of those transformations, whether you'll be profiling data, whether you'll be including QualityStage elements, and a whole host of other factors that might affect any sizing recommendataions.

For that many developers I'd be maxing the available CPU count (assuming they're all competing for resources), maxing the possible memory, and configuring lots and lots of disk. For example, 20TB of disk space just for the IADB to support profiling.

Don't even contemplate also running production in this machine.

ray.wurlod · Post by **ray.wurlod** » Wed Mar 31, 2010 6:53 pm

Moderator: please move this thread to Enterprise Edition (parallel) forum