topic Re: tOracleSCDETL in Talend Studio

tOracleSCDETL

Anonymous — Thu, 28 Jun 2018 10:53:58 GMT

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

Re: tOracleSCDETL

fdenis — Thu, 28 Jun 2018 11:11:03 GMT

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

Re: tOracleSCDETL

Anonymous — Thu, 05 Jul 2018 11:12:29 GMT

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.

Re: tOracleSCDETL

fdenis — Thu, 05 Jul 2018 15:38:31 GMT

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

Re: tOracleSCDETL

Anonymous — Fri, 13 Jul 2018 12:08:45 GMT

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

Re: tOracleSCDETL

fdenis — Mon, 16 Jul 2018 08:15:03 GMT

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 …)