sum of a column in between two limits

gssr · Post by **gssr** » Mon May 17, 2010 3:03 am

HI all..
I am having two tables
Tab1 :
sales Date
5 29/01/2010
8 31/01/2010...

Tab2 :
Start_Date End Date
29/01/2010 05/02/2010
06/02/2010 19/02/2010...

Need to get the sum of sales for each set of date limits!

Thanks in advance

ray.wurlod · Post by **ray.wurlod** » Mon May 17, 2010 3:46 am

You don't need DataStage to do that. It's straightforward DML.

DataStage is an ETL tool, not a reporting tool!

gssr · Post by **gssr** » Mon May 17, 2010 4:46 am

ray.wurlod wrote:You don't need DataStage to do that. It's straightforward DML.

DataStage is an ETL tool, not a reporting tool!
...

The tables are from different database!!

ray.wurlod · Post by **ray.wurlod** » Mon May 17, 2010 4:50 am

gssr wrote:The tables are from different database!! "

You did not state that earlier.

Use a range lookup.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon May 17, 2010 4:57 am

I don't see how having them in different database makes it an ETL requirement.

If the result will be presented in a report, it is still a reporting requirement.

You can use dblinks in Database level or any reporting tool capabilities to pull and merge the data.

gssr · Post by **gssr** » Mon May 17, 2010 5:04 am

Sainath.Srinivasan wrote:I don't see how having them in different database makes it an ETL requirement.

If the result will be presented in a report, it is still a reporting requirement.

You can use dblinks in Database l ...

Need to query it and load it to DW table.. To make the situation simple and understandable , i didnot metion it!!

Ray,
I will try range Lookup.

chulett · Post by **chulett** » Mon May 17, 2010 6:29 am

gssr wrote:Need to query it and load it to DW table.. To make the situation simple and understandable , i didnot metion it!!

Roll your eyes all you want but you are doing yourself a disservice making your situation "simpler" by leaving out critical bits of information needed to supply a proper solution. Next time - complete, not simple. Mention it. Please.