Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
bobthebuilder
Participant
Posts: 17 Joined: Mon Aug 15, 2005 3:13 pm
Post
by bobthebuilder » Mon Sep 12, 2005 2:32 pm
Hi,
Should the source files being processed via ETL should reside on the ETL server or database server.
Thanks
Bob.
DeepakCorning
Premium Member
Posts: 503 Joined: Wed Jun 29, 2005 8:14 am
Post
by DeepakCorning » Mon Sep 12, 2005 2:34 pm
ETL server.
I am not sure if we can keep it in DB server and then share it from there but the best way Iguess is to keep it in ASCl server.
ketfos
Participant
Posts: 562 Joined: Mon May 03, 2004 8:58 pm
Location: san francisco
Contact:
Post
by ketfos » Mon Sep 12, 2005 2:43 pm
Hi,
What do you mean by ASCI server?
Ketfos
DeepakCorning
Premium Member
Posts: 503 Joined: Wed Jun 29, 2005 8:14 am
Post
by DeepakCorning » Mon Sep 12, 2005 3:13 pm
Oops....I mean ETL server.....I am used to the term ASCL (ascential) ....I forgot that it is no more ascential...
ketfos wrote: Hi,
What do you mean by ASCI server?
Ketfos
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Mon Sep 12, 2005 4:21 pm
On the DataStage server is better, because you're not introducing the network as a bottleneck.
However, the only actual requirement is accessible from the DataStage server.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ferreirahe
Charter Member
Posts: 25 Joined: Wed Apr 09, 2003 12:58 pm
Post
by ferreirahe » Wed Sep 14, 2005 6:06 am
Hi Bob,
Ray is right.
A while ago we tried NFS and found out that the throughput dropped by 5 times.
But if your company can afford a high-end SAN with fiber links, you'll be in heaven...
or close to...
Regards,
Henrique Ferreira
kumar_s
Charter Member
Posts: 5245 Joined: Thu Jun 16, 2005 11:00 pm
Post
by kumar_s » Wed Sep 14, 2005 7:39 am
Hi,
Can the time spent on droping the source from Database to ETL server can be compenstated by extracting directly from Database.
Assuming source need to be droped for every run.
regards
kumar