DSXchange

All,

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

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.

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?

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.