NULL替换存储中的\ N [英] NULL is replacing \N in Storage
问题描述
在数据工厂中,在我们将数据从Oracle提取到Blob存储的任何地方复制数据 Oracle表中有 NULL 列,这些 NULL 列被替换为 \ N 在Azure Blob存储中,我不希望在存储中 \ N Blob存储中的 NULL 也是我必须要做的
In Data factory,Copy Data while we are pulling data from Oracle to blob storage, where ever NULL columns is there in Oracle table those NULL columns are replacing by \N in Azure blob storage , i dont want \N in storage , i need same NULL in blob storage also for that what i have to do
推荐答案
如果您进入高级功能"在Sink数据集的连接"选项卡下,您可以将存储在Blob存储中的"NULL"值设置为\ N以外的值.
If you go into 'Advanced Features' under the Connection tab in the Sink dataset, you can set the 'NULL' value stored in blob storage to something other than \N.
您还可以将将空列值处理为NULL"的行为-默认为true.
You can also change the behaviour of 'Treat empty column value as NULL' - the default is true.
有关更多信息,请参见此链接:https://stackoverflow.com/questions/52005554/datafactory-v2-replace-n-null-value-with-blank
See this link for more info: https://stackoverflow.com/questions/52005554/datafactory-v2-replace-n-null-value-with-blank
这篇关于NULL替换存储中的\ N的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!