Re: ETL usage
- From: "Jeje" <willgart@xxxxxxxxxxx>
- Date: Thu, 12 Oct 2006 22:00:00 -0400
I write script which generate something (like tables, SP, views...)
and creating these scripts takes a lot of time to debug them.
So creating scripts which generate scripts etc... can be good, but when you
have hundreds of same things to do.
in an ETL process, its rare to have to do 2 times the exact same things.
but if you have the time to, you can do this.
SSIS packages are XML files, so you can generate these file by creating your
own tool.
Personnaly I have never created this type of tool to generates my packages
because there is too many transformation to do etc...
Can you describe which type of generation you looking for?
sometimes there is other options then creating scripts by script.
<soalvajavab1@xxxxxxxxx> wrote in message
news:1159313134.633124.115450@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I heard from my collegue that in FME and some other ETL tools you will
creating scripts and scripts will create GUI and Mappings and it is
more effecient!
Does Informatica be able to do the same thing?
If yes, how and why we do not usually use it?
If no, what is the reason?
And generally does this make sense? ( Having script and ETL create
mapping and tranformation on the fly? )
.
- Follow-Ups:
- Re: ETL usage
- From: Peter Nolan
- Re: ETL usage
- Prev by Date: Re: ETL usage
- Next by Date: Re: VLDB nearing 85% space utilization on underlying drives.
- Previous by thread: Re: ETL usage
- Next by thread: Re: ETL usage
- Index(es):
Relevant Pages
|
