Repeating RequestID and Repeating JobID :DataModel

[poonam_kulwal]

Hi All,

I have attached a sample data. Here I need to calculate

·         How often a job run/ frequency of job run (Hourly, Daily, Monthly…)?

·         Which Source and Destination Engine has maximum load (Hourly, Daily, Monthly…)?

My point of difficulty is, I have repeating RequestID and Repeating JobID. I am planning to make RequestId and JobId as Key. I am not sure about this.

Also I am planning to create calendar based on Job Start time.

I need to perform all my analysis Hourly, Daily, Weekly, Monthly, Yearly.

Kindly guide me on how to go for creating data model.

Also formula for above two calculations.

Appreciate your help.

Thanks & Regards,

Poonam

[ahaahaaha]

Hi Poonam,

Variant of the solution is shown in the attached file.

Comments:

1. If the analysis sections is not enough (hourly, daily, monthly ...), the missing ones just need to be added to autoCalendar.

2. Based on the initial data, the operating time is much shorter than the minimum analysis interval (hour). Therefore, any particular job is attributed to the hour of "StartTime" this work. A possible transition to the next hour or the next day was not taken into account, although it is not difficult to make a small modified encoding to add additional rows when loading the original data. However, does this make sense in your case?

3. For example, several charts are given. The rest can be built by analogy.

Regards,

Andrey

[poonam_kulwal]

Thanks Andrey. THis is very helpful.