Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI
AM USING TOS OPEN EDITION FOR BIG DATA 5.6.2. I KNOW ENTERPRISE VERSION HAS CDC FEATURE ENABLED BUT OUR ORGANIZATION DOES NOT WANT TO GO WITH ENTERPRISE VERSION FOR NOW. IS THERE IS LINKS WHERE I CAN FIND THE STEPS TO ACHIEVE CDC MANUALLY IN TALEND FOR BIG DATA 5.6.2 OPEN STUDIO?
BELOW IS MY REQUIREMENT:
Am using Tos 5.6.2 open studio version. I understand CDC feature is enabled only in TIS. I m new and need to know the detailed steps on capturing Insert and updated rows on NEED BASIS USING TOS OPEN STUDIO ONLY. I m using Oracle 11. It would be great help if you can provide the flow with detailed step by step from you.
TORACLEINPUT(1)
|LOOKUP
v LOOKUP
TORACLEINPUT --------> TMAP2 <----------------HIVE TABLE (2)
(SOURCE TBL) |
|
IDENTIFY NEWLY INSERTED RECORDS
|
|
IDENTIFY ONLY CHANGED RECORDS BY (IDENTIFY BY EACH COLUMNS)
|
|
CONSOLIDATE BOTH INSERTED AND UPDATED RECORDS IN A SEPERATE TABLE WITH UPDATE FLAG AND TIMESTAMP
|
|
LOAD THE CDC DATA INTO THE ORACLE OUTPUT TABLE USING TORACLEOUTPUT COMPONENT
APPRECIATE YOUR HELP.
Thanks,
Raja