Frequent changes.....

[aag12]

Hi all,,,

I am having to change teh source tables quite frequently and eachtime i have to reimport the tables and change the transformations....

Any suggestions on how to minimise my work...Is it any way to make the changes to minm...so that ETL can automatically reflect the changes....

Thanks in advance..

 

[blom0344]

If the sources are identical in structure (same number of fields, same fieldnames, same database) a possible solution would be to create read-only views on your sources.
This way you will only have to change the DDL of the view to point to another table.

This is especially easy with SQL server, takes some more work with other databases.

Alternative is to create a union view over all sources and use the view as source. That way you will only need to use a filter in the source-qualifier to pick the right table:

SELECT 'TABLE1',A,B,C,D FROM TABLE1
UNION
SELECT 'TABLE2',U,X,Y,Z FROM TABLE2
UNION
.................................

Ties Blom
Information analyst
tbl@shimano-eu.com