BLOG | Zealous-Tech

How to Answer Tricky Interview Questions

Whenever you are facing the interview you can feel the nervousness which is natural. As soon as the interview start one of the panelists...

AWS Certification Sample Questions

Here I have put few questions with answer on AWS certification.

How to create a static website on AWS S3

In this post, I will show you how to host a static website on AWS S3

Scoop to Hive with Multilevel Partition table

Hey Guys, I came across issue while running Sqoop import to a partitioned table, and found workaround for same, sharing my two cents.....

Scenario:Count of vowels from string fields

Problem Statement : Let's consider, We have employee table and we need to find out number of vowels from first_name column. So before...

Scenario : How to remove duplicate in one table and unique value in another target(oracle tables)

In this scenario, We will consider source as a oracle table with few duplicate values. Source table structure : create table...

Fact

A Fact Table is a central table in a star schema of a data warehouse. A fact table stores quantitative information for analysis and is...

Dimension

A dimension is a structure, usually composed of one or more hierarchies that categorizes data. If a dimension hasn't got hierarchies and...

OLTP vs. OLAP

What is OLAP? Online Analytical Processing, a category of software tools which provide analysis of data for business decisions. OLAP...

Data mart

What is data mart ? A data mart (DM) can be seen as a small data warehouse, covering a certain subject area and offering more detailed...