This content has been marked as final. Show 2 replies
We have a database we are pulling from. It has columns which describe in a basic sense the data to a reasonable level of granularity. For instance, I know particular data is coming from a site called SEATTLE1. Now, I also know, separately, the latitude and longitude of SEATTLE1. I want to insert a new column for latitude and another for longitude in the load script. For each record of SEATTLE1 in the load, I want to insert the corresponding latitude and longitude values into that row.
How can this be accomplished?