Perkuliahan Data Warehouse dan OLAP

Lesson 7 :

Connecting Control Flow Tasks with Precedence Constraints = http://youtu.be/fkCLtJ7Pl6A

Lesson 8 :

Manipulating Files with the File System Task = http://youtu.be/0zFZq_q7wfY

Lesson 9 :

Coding Custom Script Tasks = http://youtu.be/CEgKSSY3Qx0

Lesson 10 :

Using the Execute SQL Task = http://youtu.be/IGYjFaquFys

Lesson 13 :

Creating a Data Flow = http://youtu.be/Q_hwmI8bfFA

Lesson 14 :

Extracting Data from Sources = http://youtu.be/_-Rx5KOr85E

Lesson 15 :

Loading Data to a Destination = http://youtu.be/sk6GuzanlnA

Lesson 16 :

Changing Data Types with the Data Conversion Transform = http://youtu.be/620tPJBwhHk

Lesson 17 :

Creating Columns with the Derived Column Transform= http://youtu.b e/qhdputeKtng

Lesson 18 :

Rolling Up Data with the Aggregate Transform = http://youtu.be/-Rx_It8EsaM

Lesson 19 :

Ordering Data with the Sort Transform = http://youtu.be/iseKh8sJZas

Lesson 20 :

Joining Data with the Lookup Transform = http://youtu.be/eWzF4gGHNv0

Lesson 21 :

Auditing Data with the Row Count Transform = http://youtu.be/YAEKSmwXshk

Lesson 22 :

Combining Multiple Inputs with the Union All Transform = http://youtu.be/YsiSYLxB16g