Doing full load with date condition

[gseckin]

Hi,

We use oracle and we'd like load spesific date and condition, but it seems it load more than the filter we passed. Is this a correct date format to filter table by datetime(0) column? Thanks

[john_wang]

Hello @gseckin ,

Could you please clarify which phase you're referring to — the Full Load (initial load) phase or the Change Processing (CDC) phase? Both phases offer a variety of options that can be tailored to your needs. If you can share more details about your scenario, we’d be happy to provide more specific and accurate suggestions.

Regards,

john.

[gseckin]

hi,
Full load phase, we want to do full load with two filter vaulues. the first one is int4 and second one is datetime(0) and datetime should be between this time 2025-06-03 13:00, 2025-06-03 15:00 . 

[john_wang]

Hello @gseckin ,

Please check the sample in article: filter on a date dataype column

Take note it takes action for Full Load phase only.

Hope it helps.

John.

[gseckin]

We just have these box, I don't see full load pasthou section.

Can I do here?

[john_wang]

Hello @gseckin ,

Please follow the steps here.

Regards,

John.