tOracleSCDETL

[Anonymous]

Hi Guys ,

I was looking for some information on tOracleSCDETL but I couldn't find any.
can anyone provide some information on this component.

why when and how we use it (tOracleSCDETL) and how it is different from tOracleSCD.

 If you can give some example it will be great

Thanks in advance

[fdenis]

You means tOracleSCDELT.
ELT run on DBserver not on the java one.

SCD is change data capture based on triggers.

you can have some help on component wem you select it on the fram an press F1.
https://help.talend.com/reader/gTkylDHdF~hAy54qDY3JfA/UfYPzai8RCvhtEdiJOqDig

[Anonymous]

Hi ,

Yes ,I mean tOracleSCDETL.

                                     I am well aware of SCD concepts .

                                     In tOracleSCD , we can implement all three types of SCD.

Then why we use tOracleSCDETL. can someone share some example for this.

[fdenis]

I cannot found tOracleSCDETL just found tOracleScdELT.
ETL Extract Transform Load
ELT Extract Load Transform (last transform on db side).
regards,

[Anonymous]

Yes It is the same .

I want to know more about this pallet.

unfortunately I can't find anything useful. Specially Why We need this pallet (tOracleSCDETL) if we already have tOracleSCD.

one.png

[fdenis]

I think it's like programming a bd trigger.
ELT run only on db side.
so it may be useful if you want to dynamicly implement your own trigger système (for log backup or security or …)