data flow from oracle to SQL server using open query
I have a table in oracle server and I am trying to move the data in a sql table, I created a linked server which works fine, when I try to move the data by specifying the where clause, it does not select the data only specified in the where clause. I use the following query. when I tried to only get order with the Calendar year 2021. below is the table I would like to query in oracle.