All,
Does datastage strong in ETL or ELT ?
which one will be good in future?
ETL vs ELT
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 1044
- Joined: Wed Sep 29, 2004 3:30 am
- Location: Nottingham, UK
- Contact:
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?
Phil Hibbs | Capgemini
Technical Consultant
Technical Consultant
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers