Skip to Content
Former Member
Mar 14, 2010 at 07:39 PM

load count design


Dear Experts,

I am into a unique situation.

The Data Flow is as below -

Three Flat File Datasources with same structure (from 3 different AS400 systems) --> ODS --> Infocube.

All three data sources load (data with same key fields) multiple times every month into ODS and then to the cube.

I have to count the number of loads (load frequency 1, 2,3, 3...) each month for each flat file data source.

Flat file will not have load count field. I need to identify souce file based on source system name and put the counter for loads in that month.

In the report, I should be able to run the report for each source system by last (latest) load number and I should also be able to make a selection, if I want to see any other load other than latest load count.

Please help.