Table deleted

Question

Hello Team,

I was transferring data from multiple tables from Source schema to Target Schema.I have achieved the correct result.

But in the source schema, these tables got truncated.I was shocked.

The below features(Allow data Truncation) are mentioned in the screenshot. Is it going to truncate the tables from the source schema?

Please advise.

Answer 1

Hey Rohit,
The truncation feature doesnt truncate the source data but Allow data truncation when converting source data to sink with different type during copy, e.g. from decimal to integer, from DatetimeOffset to Datetime.

So there might be some other reason why your data got truncated in source.