question

RohitKulkarni-6062 avatar image
0 Votes"
RohitKulkarni-6062 asked NandanHegde-7720 answered

Table deleted

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.


116152-image.png
116070-image.png

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

Please advise.

116028-image.png


azure-data-factory
image.png (22.1 KiB)
image.png (7.1 KiB)
image.png (51.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NandanHegde-7720 avatar image
1 Vote"
NandanHegde-7720 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.