Data Flow->> CDC Control Task, CDC Source, CDC Splitter

Source: Internet
Author: User

CDC control task can be synchronized from controlling CDC data, such as initialization load, LSN scope management. It can be a substitute for another approach, which is to do the same thing by calling a batch of CDC functions. From the perspective of SSIS, things are easy to program, and with the other two spaces (CDC Source, and CDC Splitter), only a few control parameters can be configured to complete the data extraction process.

CDC source queries data from a CDC-enabled data table

The CDC splitter and conditional split components feature similar features. It generates three branches of data flow: Inserts, Updates, and deletions

Loading CDC data typically requires two packages, one to do initial load and the other to do incremental load.

When it comes to CDC control Task, you need to state that the CDC control Operation property has 4 options:

1) Mark Initial load start:initial load start to get the start LSN and update cdc_state variable values

2) Mark Initial load end:initial load at the end of the Get start LSN and update cdc_state variable value

3) Mark CDC start: Record CDC range start value

4) Get processing range: Gets the LSN range value at incremental load

5) Mark processed range: The LSN range value after the incremental load is completed

Data Flow->> CDC Control Task, CDC Source, CDC Splitter

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.