ETL vs ELT

karthi_gana · Post by **karthi_gana** » Thu Sep 13, 2012 1:39 am

All,

Does datastage strong in ETL or ELT ?
which one will be good in future?

ray.wurlod · Post by **ray.wurlod** » Thu Sep 13, 2012 5:35 am

What does 'strong' mean in this context?

DataStage can do either and, indeed, can make the decision about which one to use using cost-based optimization.

PhilHibbs · Post by **PhilHibbs** » Thu Sep 13, 2012 7:28 am

And what does "ELT" mean in this context? I understand it to mean loading the source data into the database on which the target application is running and then transforming it using that database's native operations (typically stored procedures), e.g. if you're migrating or interfacing into Oracle HR then you load your source data into an XX schema within the Oracle database and then transform it into the Oracle Apps API using PL/SQL. I'm not sure how you'd do that in DataStage. What were you thinking of, Ray?

chulett · Post by **chulett** » Thu Sep 13, 2012 7:37 am

You're correct Phil except for the stored procedure part. In DataStage it is a licensed option called "Balanced Optimization" and is basically equivalent to what Informatica calls "Push Down Optimization". There is a mention of it here with the full whammy here.