If we got one extra column from source for one or two rows and these rows doesn't have the column header, How to we process these records into one extra column
But in this scenario, it's single column value which is getting treated as multiple column due to Comma separated value present, eg: 'Delhi, India' . To mitigate this, we need to configure quote character in source dataset correctly. Thankyou
could you make a video on optimisation in adf . thank you
If we got one extra column from source for one or two rows and these rows doesn't have the column header, How to we process these records into one extra column
We use alter table on SQL side and add those required columns which are not present while copying data from some source to SQL.
But in this scenario, it's single column value which is getting treated as multiple column due to Comma separated value present, eg: 'Delhi, India' . To mitigate this, we need to configure quote character in source dataset correctly. Thankyou
@@azurecontentannu6399 yes agree what you have shared. I shared a real time use case of my project.