1 Reply Latest reply on Jul 17, 2019 12:33 AM by ltrapadoux

    EDC Profile run - How to filter out historical data from profiling

    Sharad Suryavanshi New Member

      We have a large GreenPlum data warehouse that has billions of rows per table with type-2 inactive and active records.

       

      While running profiling on the JDBC resource, we like to understand if there is any way we can filter out the historical records from the run based on a table column filter condition like Record_Active = 'Y'. As the historical records are just older copies we don't really want the profiling results to consider the history records and only consider the active records.

       

      Kindly respond if there is any solution to this.