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]

No, no new entries.

My "V" output is set to a Logrow.

[TRF]

So every records from Oracle are rejected!?
Sounds strange, double check your input from both tables as the tMap looks OK.

[Anonymous]

Exactly.

I did no change on the tmap till it was working.

My entries look good too.

[TRF]

Sorry, no more idea.
Maybe you can share a capture of the whole job with row count displayed at runtime + your tMap.

[Anonymous]

i share you all my components :

[TRF]

I strongly suggest you to replace "select *" by "select col1, col2, ..." to match exactly with the schema definition.
As you have a where clause on the SQL Server table, filtering on H_DATEFIN in the tMap is not necessary (just remove the null).
Else I don't see anything abnormal.
The problem is probably due to the data.
You should run the job using the "Traces Debug" mode (Run tab + Debug Run + click Trace Debug); this could help.

[Anonymous]

The problem was the * from select * ...

Thk for your patience.

[TRF]

Great!