tOracleSCDETL

Five Stars

tOracleSCDETL

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 Smiley Happy

 

Thanks in advance

Eleven Stars

Re: tOracleSCDETL

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

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Five Stars

Re: tOracleSCDETL

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.

Eleven Stars

Re: tOracleSCDETL

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

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Five Stars

Re: tOracleSCDETL

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.

Eleven Stars

Re: tOracleSCDETL

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

Francois Denis

Tag as "solved" for others! Kudos to thanks!