Suppose we have 3 column in source file and in table we have 4 column in the sink. And we want to do one to one mapping for that and the addition column in sink we should get it as NULL while mapping it is possible?if yes.. Can you say the steps for that.
well, the steps would be the same as described in the video. For columns not present in Source, source metadata values will be null and is active flag will be set to 0
What if i dont know how the tables looks like? meaning i dont know the column names or how many column there is in every table that I have. I have 23 tables in total..
Excellent demo lokesh!!
Thanks brother
Super :)
Suppose we have 3 column in source file and in table we have 4 column in the sink. And we want to do one to one mapping for that and the addition column in sink we should get it as NULL while mapping it is possible?if yes.. Can you say the steps for that.
well, the steps would be the same as described in the video. For columns not present in Source, source metadata values will be null and is active flag will be set to 0
What if i dont know how the tables looks like? meaning i dont know the column names or how many column there is in every table that I have. I have 23 tables in total..
Why would you don't know, you may be query sys.colums table to construct a new metadata column
What to do, if we want datatype to be matched in copy activity
Match the data type? Could you please elaborate your question ❓
The process will be same for excel to sql dynamic column mapping or it'll be different ?
Should be the same. Test it out
🅿🆁🅾🅼🅾🆂🅼