Categories Data Warehouse Forward Directions Tools Queries From Hell: Data Warehousing and Analytics Blog Post author By Chris Janton Post date March 27, 2008 In the illuminate environment, the load is a single step with some aggregations needed in limited cases. When data is loaded into iLuminate, the load process indexes everything. This means that step 2 in this case is zero. ← Open Source Strategies: Enterprise Software Hierarchy of Needs → Oracle Data Archiving