Over 10 Million Study Resources Now at Your Fingertips

Download as :
Rating : ⭐⭐⭐⭐⭐
Price : $10.99
Pages: 2

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.

How It Works
Login account
Login Your Account
Add to cart
Add to Cart
Make payment
Document download
Download File
PageId: ELI002A743
Uploaded by :
Page 1 Preview
would execute the olap load step
Sell Your Old Documents & Earn Wallet Balance