Forum Discussion
SCD Type 2
Hi All, given source table customer id name city 1 A XYZ 2 B ABC 3 C KLM 4 D ADJ 5 E JKL Updates table customer id name city 1 A KKL 2 B JJK ...
EXPECTED OUTPUT
| customer id | name | city | FROM | TO |
| 1 | A | XYZ | 01-01-2000 | 01-01-2001 |
| 2 | B | ABC | 01-01-2000 | 05-01-2001 |
| 3 | C | KLM | 01-01-2000 | NULL |
| 4 | D | ADJ | 01-01-2000 | NULL |
| 5 | E | JKL | 01-01-2000 | NULL |
| 6 | A | KKL | 02-01-2001 | NULL |
| 7 | B | JJK | 06-01-2001 | NULL |