BLOG | Zealous-Tech

Jun 23, 20214 min read

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...

Jul 19, 20205 min read

AWS Certification Sample Questions

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

Jul 14, 20202 min read

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

Jul 8, 20202 min read

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.....

Jul 6, 20202 min read

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...

Jul 4, 20201 min read

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...

Jun 27, 20202 min read

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...

Jun 27, 20202 min read

Dimension

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

Jun 27, 20201 min read

OLTP vs. OLAP

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

Jun 16, 20201 min read

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...