topic Re: Insted of CDC in Talend Studio

Insted of CDC

Anonymous — Wed, 22 Nov 2017 11:23:49 GMT

Hi Experts,

I'm using talend 6.4 open studio for data integration and I came to know that CDC is not availiable in open studio

are there any options to go instead of CDC in talend, I want to load updated,deleted,inserted rows in ware house

after every 10 minutes please help me

Thanks in advance..

Re: Insted of CDC

brama — Wed, 22 Nov 2017 17:30:34 GMT

Hi,
You can make use of tmssqlscd component to find inserts and updates. You have similar scd components for most of the databases. For deletions create another job and do a inner join on key. Rejects should be the deletes.

Thanks,
Ramachandran B

Re: Insted of CDC

Anonymous — Thu, 23 Nov 2017 08:34:39 GMT

Hi,

With community version, you can match the table and compare all records to conclude the needed inserted records, updated records, and deleted records.

If you want to capture the changed data and only load these changed data into target table to achieve table sync, you can compare tables by using tMap.
The work flow should be: Target DB-->tMap(make inner join on your input and set the "Catch lookup inner join reject" as true)-->output
Source DB-->
The output will be the changed data.

Best regards

Sabrina

Re: Insted of CDC

Anonymous — Thu, 23 Nov 2017 09:24:26 GMT

How to use that component can you give me description of that component plz

Re: Insted of CDC

Anonymous — Fri, 24 Nov 2017 03:15:09 GMT

Hello,

You can use tMap component to achieve your goal in talend open source.

Here are online documents about:TalendHelpCenter:tMap and TalendHelpCenter:Mapping data sources using inner join. Hope it will be helpful for you.

Best regards

Sabrina