Skip to Main Content

Golden Gate Cloud - EXTRACT Parameter File - How to limit the Table data that we want to extract ?

Sohan AshtamkarJan 17 2022 — edited Jan 17 2022

Hi Team,
I am having a query regarding Extract Parameter File of Golden Gate.
Query: Is there a possibility where we can limit the data that we want to extract.
Example: Source Database is having a Table "XYZ" which is having data [1000 records] from 01 January 2015 and I want to extract data [only 700 records] from that table from the year 01 January 2019.
I don't want to extract all the 1000 records from the table "XYZ".
What keyword/condition needs to be used within the Extract ?
EXTRACT ext1
TABLE SCHEMA.XYZ;
TABLE SCHEMA.ABC;
Thanks,
Sohan

This post has been answered by AlexLima-Oracle on Jan 18 2022
Jump to Answer
Comments
Post Details
Added on Jan 17 2022
2 comments
35 views