Wanted Comments on the expected run time.
Posted: Fri Oct 27, 2006 4:18 am
Hello friends,
I have a Job Sequence consisting of two Jobs.
I am providing you with the number of stages and some expected data that the jobs are expected to handle :
First Job : 17 Look-ups (12 using Hashed File and 5 using Database tables).Average Rows in a hashed file is around 2000-3000.Database tables references will have less than 200 rows.
7 Transformers.
8 IPCs.
Source is a Sequential file containing around 5000 rows and target is two Database tables.
Second Job : 12 Look-ups (9 using Hashed File and 3 using Datastage tables).Average Rows in 6 hashed filea is around 800-1000 and 3 hashed file would have 2000-3000 rows.Database tables references will have less than 200 rows.
6 Transformers.
3 IPCs.
Source is a Sequential file containing around 30 Million rows and target is three tables.
We are in development phase right now and the above is is the expected Data that the jobs have to handle.
Please post ur comments on the expected time the Job Sequence will take to complete the execution.
Ur comments are very important for me....
Thanx in advance!!!
I have a Job Sequence consisting of two Jobs.
I am providing you with the number of stages and some expected data that the jobs are expected to handle :
First Job : 17 Look-ups (12 using Hashed File and 5 using Database tables).Average Rows in a hashed file is around 2000-3000.Database tables references will have less than 200 rows.
7 Transformers.
8 IPCs.
Source is a Sequential file containing around 5000 rows and target is two Database tables.
Second Job : 12 Look-ups (9 using Hashed File and 3 using Datastage tables).Average Rows in 6 hashed filea is around 800-1000 and 3 hashed file would have 2000-3000 rows.Database tables references will have less than 200 rows.
6 Transformers.
3 IPCs.
Source is a Sequential file containing around 30 Million rows and target is three tables.
We are in development phase right now and the above is is the expected Data that the jobs have to handle.
Please post ur comments on the expected time the Job Sequence will take to complete the execution.
Ur comments are very important for me....
Thanx in advance!!!