Hi Jérôme !
When you use different technologies on your source and target in a mapping, xDI will always add a LOAD step. You will see the same if you use the same technology (and possibly the same instance) but with your source and target in different metadatas. Sure It's not clean, but it's the principle.
And automatically, if there is a LOAD step, you always have a temporary table created to store your source elements. This table will be used on target to integrate your data, and probably to control data, or to detect data already created on target to perform insert/update mechanism, etc...
Don't forget that xDI is an ELT, so you always have an L (load) step, before the target.
Jérôme LESTEVEN
We edit a very basic mapping from a SQL Server table to the same table in PostgreSQL technologie. This mapping has just one filter on the source table.
The goal is to truncate the cible table and after to load it with source data with one filter on the source table.
The mapping bring two template and even with the "append mode" there is an intermediate table wich is create (and drop at the end).
We would like to have a direct "select ... from <source> where <clause>" and after a "insert into <cible> values ( :field1 , :filed2 , ...)" without temporary table.
Is it possible with standard template or do we have to create our specific template ?