DS Transaction data loads

[rickbi]

Hi All

I am loading Transaction data Through Fact Build for the Existing data from source to Target. Now Can some one sujjest me the best approch for the Weekly Loads for the new Data comming to the Source System, As i do not want to load the entire data (full refresh)and load only the data that comes in that week(Newly arrived data), What is the best approch to do so.
Thanks in Advance
Rick

 

[CognosProfessional]

If you are talking about Transformer, I would say use the incremental update function to build cubes. But, your terms are mis-understood if you are talking Cognos. Target? source System? Sounda likes you are talking DB terms... Are you loading data to update a database or a cube?

CP

 

[rickbi]

Hi
I am Building Datamart with Cognos-Decision Stream, I have data in Source and i am trying to Bring it into Target DataMarts,Here I would like to know is there any Automated Process for the Weekly Data(New data)Comming into Source System to Load into DataMarts Using Fact Builds of DS.
Thanks
Rickbi