Filtering data from Oracle and SQL Server

[Anonymous]

Hi all,

I'm trying to update data from an Oracle Database to a SQL Server Database.
If data is already registered to SQL Server, i don't want to register this data again.

I did my workspace like this : (First capture)

I configured my TMap like this : (Second capture)

I think my mistake is the Inner Join. I don't know if i'm doing it well.

Any help is greatly appreciated.

Regards.

[TRF]

Can you share your lookup table settings including thé SQL query?

[Anonymous]

Sure.

Annotation 2019-10-14 160122.png
Annotation 2019-10-14 160155.png

[TRF]

Did you try to replace the tMap lookup model by "load once" (check the name of the option)?

[Anonymous]

Yep, but did nothing better.

I don't know if the problem come from the join between my 2 tables. Cause all my data returned from row2 (check the second screen from my first topic) are null. But there is no null value in my table.

I tried every Lookup Model, every Join Model, every Match Model from row2.

[TRF]

So, tDBInput_1 should be related to Oracle database and tDBInput_2 to SQL Server.

In the tMap, change "Recharger à chaque ligne" by "Load once" and change "Catch output reject" to false on the output flow (tMap right side).

It should work like this.

[Anonymous]

"So, tDBInput_1 should be related to Oracle database and tDBInput_2 to SQL Server."

      It's true.

I tried your params, but didn't work.

Again Null values for all my table sql server.

[TRF]

What do you mean with "Again Null values for all my table sql server"?

Null value for H_DATEFIN is not required as soon as you have it into the where clause.
For the rest, no problem.
Maybe could you share again the last version of your tMap.

[Anonymous]

first screen is TMap config update.

Second screen is what my table look like.

What i was trying to explain is :"after the TMap, NIVNATLIBL_1 is always null instead of ... "

Annotation 2019-10-14 165440.png
Annotation 2019-10-14 165441.png

[TRF]

Sorry, my mistake!

SQL Server must be the main table and Oracle the lookup.

Don't change anything else to get records existing into SQL Server but not into Oracle (thank's to the option "catch inner join reject").