...
CustomerID | FirstName | LastName |
---|---|---|
1 | Darth | Vader |
2 | Luke | Skywalker |
3 | HanHans | Solo |
Also assume that you have new traffic that contains the following data:
...
CustomerID | FirstName | LastName |
---|---|---|
1 | Darth | Vader |
2 | Luke | Skywalker |
3 | HanHans | Solo |
4 | Obi-Wan | Kenobi |
Update
Updates matching records with new data and creates new records as needed.
...
CustomerID | FirstName | LastName |
---|---|---|
1 | Darth | Maul |
2 | Luke | Skywalker |
3 | HanHans | Solo |
4 | Obi-Wan | Kenobi |
Overwrite
...
CustomerID | FirstName | LastName |
---|---|---|
1 | Darth | Maul |
2 | Luke | Skywalker |
3 | HanHans | Solo |
Anchor | ||||
---|---|---|---|---|
|
...