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.
Thanks.