Problem in deploying data with DDT


Author
Message
GRocchi
GRocchi
StrataFrame Beginner (48 reputation)StrataFrame Beginner (48 reputation)StrataFrame Beginner (48 reputation)StrataFrame Beginner (48 reputation)StrataFrame Beginner (48 reputation)StrataFrame Beginner (48 reputation)StrataFrame Beginner (48 reputation)StrataFrame Beginner (48 reputation)StrataFrame Beginner (48 reputation)
Group: Forum Members
Posts: 18, Visits: 56
I have a project and a table which I'd like to get deployed by the DDT.

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

Reply
GRocchi
GRocchi
StrataFrame Beginner (48 reputation)StrataFrame Beginner (48 reputation)StrataFrame Beginner (48 reputation)StrataFrame Beginner (48 reputation)StrataFrame Beginner (48 reputation)StrataFrame Beginner (48 reputation)StrataFrame Beginner (48 reputation)StrataFrame Beginner (48 reputation)StrataFrame Beginner (48 reputation)
Group: Forum Members
Posts: 18, Visits: 56
Sorry for delay, but I'm rather busy at the moment:

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

Attachments
testDDT.pkg (268 views, 14.00 KB)
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search