在“复制数据活动”中使用模式映射中的表达式或函数。 [英] Use of expression or functions in schema mapping in Copy Data Activity.
问题描述
HI,
是否可以在copydata活动的schemaMappings部分中使用表达式或函数?
让我把我想要实现的目标。请参阅schemaMapping - >名称属性。
{
" name" :
" CopyFromMongoDBToOracle" ,
" type" :
" Copy" ,
" typeProperties" :
{ " source" :
{ " type" :
" MongoDbV2Source"
}, " sink" :
{ " type" :
" OracleSink"
}, " translator" :
{ " type" :
" TabularTranslator" ,
" schemaMapping" :
{ " name" :
" @concat($。firstName,'',$。lastName)" ,
" orderDate" :
" $ .date" ,
" order_pd" :
" prod" ,
" order_price" :
" price" ,
" city" :
" $ .city [0] .name"
}, " collectionReference" :
" $。orders"
}}}
分层数据的复制数据活动是否可以实现。
你好Govind,
<我确实尝试了这个,但没有成功。我正在尝试联系一些内部团队,看看他们是否可以在这里提供帮助。一旦我收到他们的消息,我会更新你。
HI,
Is it possible to use expression or functions in the schemaMappings section of the copydata activity ?
Let me put what I am trying to achieve. See the schemaMapping -> name property.
{ "name": "CopyFromMongoDBToOracle", "type": "Copy", "typeProperties": { "source": { "type": "MongoDbV2Source" }, "sink": { "type": "OracleSink" }, "translator": { "type": "TabularTranslator", "schemaMapping": { "name": "@concat($.firstName,' ' ,$.lastName)", "orderDate": "$.date", "order_pd": "prod", "order_price": "price", "city": " $.city[0].name" }, "collectionReference": "$.orders" } } }
Is this achievable for copy data activity for hierarchical data.
Hello Govind ,
I did tried this , but did not worked out . I am trying to reach to some internal team and see if they can help here . I will update you once I hear from them .
这篇关于在“复制数据活动”中使用模式映射中的表达式或函数。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!