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.

[Anonymous]

I'm looking to convert date to text then.

Can i check up every fileds except date field ? 

[TRF]

For sure

[Anonymous]

This one should work ? but it doesn't.

[TRF · Accepted solution]

What doesn't work?
No rows on the output?
What if you set "Catch output reject" to false?
It should be setted this way.

[Anonymous]

So, the problem was the datetime format.
With "catch output reject" set to false, it work.

Thk for you help my dude.

[TRF]

Alleluia !

[Anonymous]

I'm really sorry ... 

Again me.

Was wroking but not anymore, don't know why ...

didn't change any parameter 

I want to die ><

[TRF]

Everything looks good in the tMap. What's happening?

[Anonymous]

That give me my 6 rows instead of 2.

When i pushed the topic to resolved, gived me my 2 rows.

[TRF]

Because of new records inserted into the target table?