Source file location

bobthebuilder · 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 · 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 · Post by **ketfos** » Mon Sep 12, 2005 2:43 pm

Hi,
What do you mean by ASCI server?

Ketfos

DeepakCorning · 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 · 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.

ferreirahe · 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 · 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