Skip to Content

pushdown the join between two different database tables

Hi ,

I have two source tables . Each table coming from different database system. ( One is from Oracle and another one is Sybase IQ). But join is not going to push down due to different source databases. But one table have large volume ( 10 + million) of data and second one I have less than 100 records. Due to not push down I need to read all 10+ million data to join.

Is there any way to push down the join between two different database tables.

Thanks & Regards,

Ramana.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 17, 2017 at 01:13 PM

    Copy the small table to the other database first (use a Data_Tranfer transform to do so). Then join.

    Add comment
    10|10000 characters needed characters exceeded

    • Dirk Venken Venkata Ramana Paidi

      That's not the best design then. You need some staging on Oracle for your table 1 CDC. Or don't materialise and just use a where-clasue (or a view) to filter out new and modified records only.