Hi, I'm still very new to Azure Data Factory and thusfar have only used the copy activity using input from blob storage and writing to Azure SQL Database.
Now I have a situation where I have in input .csv file with 4 fields from blob storage. 3 of the fields will be mapped directly from the input .csv to the sql table. The 4th field is a string containing a login name (such as ig02377) that I need to use to read an employee table and get the corresponding guid for the login name. The guid will then be stored in the sql table instead of the login name.
So, I've been trying to figure out the best way to accomplish this. Do I use the copy activity as normal and accomplish this in a stored procedure? Or do I need to use the Lookup and ForEach activities to accomplish this?
I've tried to use the copy activity with a stored procedure but the problem that I encounter comes from the source being a string and the sink being a guid. I've also tried to find instructional videos online but the ones I have found are not my exact situation.
I would appreciate any insight and especially if someone has done the same type of thing in ADF.
Thanks!
Sallie Cottingham