Page 1 of 1
Source file location
Posted: Mon Sep 12, 2005 2:32 pm
by bobthebuilder
Hi,
Should the source files being processed via ETL should reside on the ETL server or database server.
Thanks
Bob.
Posted: Mon Sep 12, 2005 2:34 pm
by DeepakCorning
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.
Posted: Mon Sep 12, 2005 2:43 pm
by ketfos
Hi,
What do you mean by ASCI server?
Ketfos
Posted: Mon Sep 12, 2005 3:13 pm
by DeepakCorning
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
Posted: Mon Sep 12, 2005 4:21 pm
by ray.wurlod
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.
Posted: Wed Sep 14, 2005 6:06 am
by ferreirahe
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...
![Wink ;-)](./images/smilies/icon_wink.gif)
or close to...
Regards,
Henrique Ferreira
Posted: Wed Sep 14, 2005 7:39 am
by kumar_s
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