SCD

Thu, 18 Jun 2015 09:43:22 GMT

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

Help me implementing the same.

Thanks in advance

Re: SCD

swuehl — Thu, 18 Jun 2015 12:31:34 GMT

Ruchi,

I think this question has been answered in another thread. In future, please try to avoid multiple postings.

Thanks.