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 ?
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 ?