How to copy selected columns using copy activity.
how to parameterize dataset, lookup, foreach.
• 🔴 Live Demo | DataSet Parameterizatio...
refer to below template:
{
"type": "TabularTranslator",
"mappings": [
{
"source": {
"name": "SNo",
"type": "String",
"physicalType": "String"
},
"sink": {
"name": "Sno",
"type": "Int32",
"physicalType": "int"
}
},
{
"source": {
"name": "Country/Region",
"type": "String",
"physicalType": "String"
},
"sink": {
"name": "Country",
"type": "String",
"physicalType": "nchar"
}
},
{
"source": {
"name": "FilePath",
"type": "String",
"physicalType": "String"
},
"sink": {
"name": "FilePath",
"type": "String",
"physicalType": "nchar"
}
}
]
}