Pages: 2
Rating : ⭐⭐⭐⭐⭐
Price: $10.99
Page 1 Preview
would execute the olap load step

Would execute the olap load step


Chapter 9

Data Transformation with IBM DB2 Data Warehouse Center


In the first process flow in Figure 9.7 (left flow), the target of the “Using transients-SQL” step is defined as a transient table called TRANSIENT. This table is then used as a source to the two OLAP steps that populate two dif-ferent cubes. Now as each of the OLAP steps executes, prior to them loading the cube, it will run the “Using transients-SQL” step, and once complete, the OLAP steps will complete. In this case, you will notice that the schedules are not on the “Using transients-SQL” step, but on each individual OLAP step indicated as by the small clock icon. In fact, if you were to schedule a step that produces a transient table, you would get a runtime error.

You are viewing 1/3rd of the document.Purchase the document to get full access instantly

Immediately available after payment
Both online and downloadable
No strings attached
How It Works
Login account
Login Your Account
Place in cart
Add to Cart
send in the money
Make payment
Document download
Download File

Uploaded by : Jennifer Sanchez

PageId: ELI002A743