Hi Folk,
Just an Info.
What would be the comprehensive hardware configuration for a windows system to executing a build job(on windows platform) of 50 millions of records? If specific, this job perform 25 lookups in several tables and load into remote database server. Consider an environment of seperate source DB server, target DB server and ETl job execution server. This info will helps me to understand idle execution time will required for a concered job. I'm focusing on processor speed and memory space to do possible computations.
Thanks,
Prashant
Hardware configuration for DataStage System (Server)
-
- Participant
- Posts: 3
- Joined: Tue Jan 06, 2009 3:54 am
Are you certain that this is a TX question?
There is insufficent information to make any recommendations at all. 50 Million records with a key and one column is quite different from 50 million rows with 100 columns. Just reading & writing the columns could be complex (partitioning, key distribution, updates/inserts, etc.). Is there any processing going on? If so, what sort?
There is insufficent information to make any recommendations at all. 50 Million records with a key and one column is quite different from 50 million rows with 100 columns. Just reading & writing the columns could be complex (partitioning, key distribution, updates/inserts, etc.). Is there any processing going on? If so, what sort?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3
- Joined: Tue Jan 06, 2009 3:54 am