Big Data

Data Warehousing on AWS Redshift Case study

Scenario Create the Dataset to set in Redshift cluster using star schema design. Data warehouse databases commonly use a star schema design, in which a central fact table contains the core data for the database and several dimension tables provide descriptive attribute information for the fact table. The fact table joins each dimension table on…

Create an Amazon Lex Bot Using a Blueprint

Create an Amazon Lex Bot Using a Blueprint In this exercise, you do the following: Create your first Amazon Lex bot and test it in the Amazon Lex console. For this exercise, you use the OrderFlowers blueprint. Create an AWS Lambda function and test it in the Lambda console. While processing a request, your bot…

Bigdata Storage & databases on AWS Use Case

Scenario Create Amazon Dynamo DB Table using default table setting. The table name must be “Song” and the Partition key must be “ArtistName” – String Type. Add these items in the table “Song.” ArtistName(String) Song(String) Sam “My name is Sam” Anil “My name is Anil” Amit “My name is Amit” Query the Sam’s song and…

Running a Hadoop MapReduce Job Using Custom JAR

Running a Hadoop MapReduce Job Using Custom JAR In this demo, you will run a sample Java program of word count and will execute the same using EMR cluster Solution Step 1 – Create a MapReduce Java Program You need to first develop a Java program to count the occurrence of a word in any…