Need to implement below logic in datastage 8.1
Posted: Wed Mar 02, 2011 1:40 am
HI All,
I need to implement below logic in datastage.Please help me out.I have my input data as:
History
Date Store Sku Price
1-Dec-10 A 1 10
1-Dec-10 A 2 12
1-Dec-10 B 1 5
1-Dec-10 B 2 8
1-Dec-10 C 1 15
2-Dec-10 A 1 10
2-Dec-10 A 2 12
2-Dec-10 B 1 5
2-Dec-10 B 2 8
2-Dec-10 C 1 15
3-Dec-10 A 1 7
3-Dec-10 A 2 12
3-Dec-10 B 1 6
3-Dec-10 B 2 8
3-Dec-10 C 1 15
4-Dec-10 A 1 7
4-Dec-10 A 2 12
4-Dec-10 B 1 6
4-Dec-10 B 2 8
4-Dec-10 C 1 15
5-Dec-10 A 1 10
5-Dec-10 A 2 12
5-Dec-10 B 1 5
5-Dec-10 B 2 8
5-Dec-10 C 1 15
and then I need my ouput as below:
Output
Date Store Sku Price
1-Dec-10 A 1 10
3-Dec-10 A 1 7
5-Dec-10 A 1 10
1-Dec-10 A 2 12
1-Dec-10 B 1 5
3-Dec-10 B 1 6
1-Dec-10 B 2 8
1-Dec-10 C 1 15
Could anyone please help me out in achiving this logic.
Thanks & Regards,
Kalpana.
I need to implement below logic in datastage.Please help me out.I have my input data as:
History
Date Store Sku Price
1-Dec-10 A 1 10
1-Dec-10 A 2 12
1-Dec-10 B 1 5
1-Dec-10 B 2 8
1-Dec-10 C 1 15
2-Dec-10 A 1 10
2-Dec-10 A 2 12
2-Dec-10 B 1 5
2-Dec-10 B 2 8
2-Dec-10 C 1 15
3-Dec-10 A 1 7
3-Dec-10 A 2 12
3-Dec-10 B 1 6
3-Dec-10 B 2 8
3-Dec-10 C 1 15
4-Dec-10 A 1 7
4-Dec-10 A 2 12
4-Dec-10 B 1 6
4-Dec-10 B 2 8
4-Dec-10 C 1 15
5-Dec-10 A 1 10
5-Dec-10 A 2 12
5-Dec-10 B 1 5
5-Dec-10 B 2 8
5-Dec-10 C 1 15
and then I need my ouput as below:
Output
Date Store Sku Price
1-Dec-10 A 1 10
3-Dec-10 A 1 7
5-Dec-10 A 1 10
1-Dec-10 A 2 12
1-Dec-10 B 1 5
3-Dec-10 B 1 6
1-Dec-10 B 2 8
1-Dec-10 C 1 15
Could anyone please help me out in achiving this logic.
Thanks & Regards,
Kalpana.