Tentamen (uitwerkingen)

Data Warehousing Interview Questions And Answers Guide

0 keer verkocht

Vak
Data Warehousing

Instelling
Data Warehousing

Data Warehousing Job Interview Preparation Guide. Global Guideline . COM Question # 1 What is Meta data? Answer: Metadata is data about data. E.g. if in data mart we are receiving any file. Then metadata will contain information like how many columns, file is fix width/limited, ordering ...

[Meer zien]

Voorbeeld 3 van de 19 pagina's

Bekijk voorbeeld

Geupload op 3 augustus 2024
Aantal pagina's 19
Geschreven in 2024/2025
Type Tentamen (uitwerkingen)
Bevat Vragen en antwoorden

data warehousing interview questions and answers
question 1 what is meta data
question 2 briefly state different between data

Instelling Data Warehousing
Vak Data Warehousing

Volgen

TIFFACADEMICS

Lid sinds 2 jaar 605 documenten verkocht

€17,65

In winkelwagen

Op verlanglijstje

100% tevredenheidsgarantie
Direct beschikbaar na je betaling
Lees online óf als PDF
Geen vaste maandelijkse kosten

Data Warehousing Interview
Questions And Answers Guide.

Global Guideline.
http://www.globalguideline.com/

, Data Warehousing Interview Questions And Answers

G
Data Warehousing Job Interview Preparation Guide.
lo
ba
lG
Question # 1
What is Meta data?
ui
Answer:-
Metadata is data about data. E.g. if in data mart we are receiving any file. Then metadata will contain information like how many columns, file is fix width/limited,
ordering of fields, data types of field etc.
d
Read More Answers.
el
Question # 2
Briefly state different between data ware house & data mart?
in
Answer:-
Data warehouse is made up of many datamarts. DWH contain many subject areas. However, data mart focuses on one subject area generally. E.g. If there will be
DHW of bank then there can be one data mart for accounts, one for Loans etc. This is high-level definitions.
e
Read More Answers.

Question # 3
.C
What is galaxy schema?
Answer:-
Galaxy schema is also known as fact constellation scheme. It requires no of fact tables to share dimension tables. In data, wares housing mainly the people are using
the conceptual hierarchy.
O
Read More Answers.
M
Question # 4
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet
the condition.
Answer:-
Informatica filter transformation default value is 1 i.e. true. If you place a break point on filter transformation and run the mapping in a debugger mode, you will find
these values 1 or 0 for each row passing through filter. If you change 0 to 1, the particular row will be passed to next stage.
Read More Answers.

Question # 5
After we create a SCD table, can we use that particular Dimension as a dimension table for Star Schema?
Answer:-
Yes.
Read More Answers.

Question # 6
What is Core Dimension?
Answer:-
Core Dimension is a Dimension table, which is used dedicated for single fact table or Datamart. Conform Dimension is a Dimension table which is used across fact
tables or Data marts.
Read More Answers.

Question # 7
How much data hold in one universe.
Answer:-

Copyright © http://www.GlobalGuideline.COM Page 2/19

, Data Warehousing Interview Questions And Answers

Universe does not hold any data. However, practically the universe is known to have issues when the objects cross 6000.
Read More Answers.

Question # 8
Can any one explain about Core Dimension, Balanced Dimension, and Dirty Dimension?
Answer:-
G
Dirty Dimension is nothing but Junk Dimensions. Core Dimensions are dedicated for a fact table or Data mart. Conformed Dimensions are used across fact tables or
Data marts.
Read More Answers.
lo
Question # 9
ba
Can any one explain the Hierarchies level Data warehousing.
Answer:-
In Data warehousing, levels are columns available in dimension table. Levels are having attributes. Hierarchies are used for navigational purpose; there are two types
of Hierarchies. You can define hierarchies in top down or bottom up.
lG
1. Natural Hierarchy: Best example is Time Dimension - Year, Month, Day etc. In natural Hierarchy definite relationship exists between each level
2. Navigational Hierarchy: You can have levels like
Ex - Production cost of Product, Sales Cost of Product.
Ex - Lead Time defined to procure, Actual Procurement time,
In this, two levels need not to have relationship. This Hierarchy is created for navigational purpose.
ui
Read More Answers.

Question # 10
d
What is data cleaning? How can we do that?
Answer:-
el
Data cleaning is a self-explanatory term. Most of the data warehouses in the world source data from multiple systems - systems that were created long before data
warehousing was well understood, and hence without the vision to consolidate the same in a single repository of information. In such a scenario, the possibilities of
the following are there:
in
* Missing information for a column from one of the data sources;
* Inconsistent information among different data sources;
* Orphan records;
* Outlier data points;
e
* Different data types for the same information among various data sources, leading to improper conversion;
* Data breaching business rules
In order to ensure that the data warehouse is not infected by any of these discrepancies, it is important to cleanse the data using a set of business rules, before it makes
.C
its way into the data warehouse.
Read More Answers.

Question # 11
O
What is dimension modeling?
Answer:-
M
A logical design technique that seeks to present the data in a standard, intuitive framework that allows for high-performance access. There are different data modeling
concepts like ER Modeling (Entity Relationship modeling), DM (Dimensional modeling), Hierarchal Modeling, Network modeling. However, popular are ER and
DM only.
Read More Answers.

Question # 12
Where the cache files stored?
Answer:-
Caches are stored in Repository.
Read More Answers.

Question # 13
How can you import tables from a database?
Answer:-
In Business Objects Universe Designer you can open Table Browser and select the tables needed then insert them to designer.
Read More Answers.

Question # 14
What is drilling across?
Answer:-
Drill across corresponds to switching from 1 classification in 1 dimension to a different classification in different dimension.
Read More Answers.

Question # 15

Copyright © http://www.GlobalGuideline.COM Page 3/19

Dit zijn jouw voordelen als je samenvattingen koopt bij Stuvia:

Bewezen kwaliteit door reviews

Studenten hebben al meer dan 850.000 samenvattingen beoordeeld. Zo weet jij zeker dat je de beste keuze maakt!

In een paar klikken geregeld

Geen gedoe — betaal gewoon eenmalig met iDeal, creditcard of je Stuvia-tegoed en je bent klaar. Geen abonnement nodig.

Direct to-the-point

Studenten maken samenvattingen voor studenten. Dat betekent: actuele inhoud waar jij écht wat aan hebt. Geen overbodige details!

Veelgestelde vragen

Wat krijg ik als ik dit document koop?

Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.

Tevredenheidsgarantie: hoe werkt dat?

Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.

Van wie koop ik deze samenvatting?

Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper TIFFACADEMICS. Stuvia faciliteert de betaling aan de verkoper.

Zit ik meteen vast aan een abonnement?

Nee, je koopt alleen deze samenvatting voor €17,65. Je zit daarna nergens aan vast.

Is Stuvia te vertrouwen?

4,6 sterren op Google & Trustpilot (+1000 reviews)

Afgelopen 30 dagen zijn er 68175 samenvattingen verkocht

Opgericht in 2010, al 15 jaar dé plek om samenvattingen te kopen

Begin nu gratis

Tentamen (uitwerkingen)

Data Warehousing Interview Questions And Answers Guide

Document informatie

Onderwerpen

Geschreven voor

Verkoper

Ontvangen beoordelingen

Voorbeeld van de inhoud