If I run the DDT and the target table is empty in the database I get 74 records (that's correct)If instead the table has records in it (the 74 I just exported) the DDT says he has imported 74 records, but when I see the table actually only 20 exist.
The Deployment data package is configured with the Overwrite option (I expect to rewrite the whole table every time) and the table has a primary key made by two column (this last thing is perhaps the only difference between other tables that are working well)
What can the problem be? Gianpaolo Rocchi
Attached is my file: the table of interest is the "CausaliConfigurazioni" Table:I am sure that the table in my source db has 74 records, when I deploy the data the DDT says "74 records imported" but when I look into the table I find the records to be only 20
Incidentally I noticed that the records are suspiciously the same as if I would try to Insert the records one at a time and if the primary key would be only made of one field(so that some records overwrite each other)
Perhaps I should tell the DDT that the table has 2 fields as Primary key? How can I do this?
Thanks in advance and best regards Gianpaolo Rocchi