Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Incremental build in Decision stream

Status
Not open for further replies.

kajarekar

MIS
Mar 31, 2001
34
KW
Hello Experts,

I would like to have some tips on incremental fact builds using decision stream.

My requirement is as follows

On daily basis, i will be populating a fact table which will have one date column also.

In the subsequent builds, decision stream should look in the target table to find out what is the maximum date in the date column and populate only those rows where the date in the source data base is greater than the maximum date in the target data mart.

Any hints ?

Thanks in advance
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top