Get Instant Help From 5000+ Experts For
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing:Proofread your work by experts and improve grade at Lowest cost

And Improve Your Grades
myassignmenthelp.com
loader
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!
Free Quote
wave
COMP810 Data Warehousing and Big Data

Data specifications The assessment provides a script file named “Transaction_and_MasterData_Generator.sql”. By executing the script it will create two tables in your account. One is transaction table with 10,000 records populated in it. This data will be generated randomly based on 100 products, 50 customers, 10 stores, and one year time period as a date - from 01-Jan-19 to 31-Dec-19. The values for the quantity attribute will be random between 1 and 10. The other is MASTERDATA table with 100 records in it. The structure of both tables with their attribute names and data types gis given in Figure 4. The attributes TRANSACTION_ID and product data are primary keys in TRANSACTION and MASTERDATA tables respectively. TRANSACTION Attributes Structures for TRANSACTION and MASTERDATA tables 6.Implementation of INLJ To implement INLJ algorithm you will implement the following steps. 1.Read 50 tuples from TRANSACTION table as input data into a cursor. The cursor is a user defined data type in PLSQL which works as a list and is used to store multiple records in memory for processing. 2.Read the cursor tuple by tuple and for each tuple retrieve the relevant tuple from MASTERDATA table using PRODUCT_ID as an index and add the required attributes (mentioned in Figure 2) into the transaction tuple (in memory). 3.The transaction tuple with new attributes is to be loaded into DW. Before loading the tuple into DW you will check whether the dimension tables already contain this information. If yes, then only update the fact table otherwise update the required dimension tables and the fact table. 4.Repeat steps 1 to 3 until you load all the data from TRANSACTION table to DW.

support
Whatsapp
callback
sales
sales chat
Whatsapp
callback
sales chat
close