Hi Team,
Kindly help me resolve the following query using the SCD solution
Well, I have the following Inline table
LOAD * INLINE
[
Product, ProdName, Price, Updated
123, Watch, 150$, 1/1/2015
134, Fruit, 30$, 1/1/2015
145, Ring, 3000$, 3/1/2015
123, Watch, 125$, 5/1/2015
123, Watch, 119$, 5/5/2015
134, Fruit , 50$, 5/5/2015
145, Ring, 2500$, 5/12/2015
234, Pen, 12$, 5/17/2015
312, Jeans, 50$, 6/9/2015
];
Using the above input table, I need to get the below reults
|
| Product | ProdName | Price | Updated | From | To Date |
| 123 | Watch | 150$ | 1/1/2015 | 1/1/2015 | 4/30/2015 |
| 123 | Watch | 125$ | 5/1/2015 | 5/1/2015 | 5/42015 |
| 123 | Watch | 119$ | 5/5/2015 | 5/5/2015 | 6/18/2015 |
Help me implementing the same.
Thanks in advance
