| Date: | Wed, 25 Feb 2009 22:17:32 -0800 |
| Reply-To: | Madhu G <c2madhu@GMAIL.COM> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | Madhu G <c2madhu@GMAIL.COM> |
| Organization: | http://groups.google.com |
| Subject: | Need Help in DI |
|
| Content-Type: | text/plain; charset=ISO-8859-1 |
Hi All,
Can any body help me in the below senario ..it is really urgent for me
and not able to find out the way of doing in DI Studio....
Foundation Table: DAY 1
Linecode=1;stock=100;
Linecode=2;stock=99;
Linecode=3;stock=200;
--------------------------------------
Source Table: DAY 2
Linecode=1;stock=100;
Linecode=2;stock=299;
.... linecode 3 deleted so not in table
-----------------------------------------------
Incremental Table: DAY 2
Linecode=2;stock=299;
--------------------------------------
We want the following:
------------------------------------
Foundation Table: DAY 2
Linecode=1;stock=100;
Linecode=2;stock=299;
Linecode=3;stock=0;
------------------------------------
Thanks in advance.
Cheers,
Kiran
|