Skip to Content
Former Member
May 12, 2005 at 11:51 PM

Loading of Master/Trans Data with specific timing ?


Hi Folks,

Just wondering from a planning/performance perspective, is there any standard or a better way to implement master data & trans data loads in sync? Are there any benchmarks as to if there are certain # of records, then schedule it at a later time or something ? Eg: Scheduling extraction of Master Data First and then Loading in data targets at around 7 p.m. and then scheduling the load of TransData at maybe 9 p.m. in the same data target ? Obviously would automate this via Proc chains but does this process make sense or are there any better approaches. Would appreciate all the feedback.