top of page


Search


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

zealous-tech
Jun 23, 20214 min read
4
0


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

zealous-tech
Jul 19, 20205 min read
19
0


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

zealous-tech
Jul 14, 20202 min read
73
0


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

zealous-tech
Jul 8, 20202 min read
27
0


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

zealous-tech
Jul 6, 20202 min read
64
0


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

zealous-tech
Jul 4, 20201 min read
13
0


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

zealous-tech
Jun 27, 20202 min read
12
0


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

zealous-tech
Jun 27, 20202 min read
10
0


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

zealous-tech
Jun 27, 20201 min read
4
0


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

zealous-tech
Jun 16, 20201 min read
8
0
bottom of page