Re: Build Indexes as Scheduled task?

PMFJI. Informatica runs as a *client* for ETL sessions? Doesn't this cause a *huge* network bottleneck when processing large volumes of external data?
Please forgive the apparently daft question; I'm very familiar with ETL as a process, but *not* with third party ETL tools. I'm seeking any relevant information because my organisation is planning to set up a new DW and is evaluating third party ETL tools.

Thanks in advance,
Paul

"Iain Dickens" <iain.dickens_at_wgrant.com> wrote in message news:42d2ae6c.0208270402.5b951e62_at_posting.google.com...
> Hi,
>
> ETL (informatica) is on Win2K and does have pre/post session where I
> can call batch file that runs scripts to drop/build indexes. This is a
> little messy as I have to maintain batch files, SQL files and ensure
> if ETL schedules are altered that the PRE/POST session is amended.
> I was hoping to submit from DBMS_JOBS and maintain only two procedures
> (drop and create) where I can apply conditions at database level. As
> PL/SQL does not support DDL directly I am really looking for an
> alternative where I maintain 2 procedures (or similar). But obviously
> less maintenance than post session from ETL tool.
> It may well be I would be better sticking to what I have at the moment
> as it does work.
>
> Thanks
>
> Iain
Received on Wed Aug 28 2002 - 14:07:56 CDT