Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

Could any one to tell Fact table Partitioning?

2 7023

how can i generate a report by getting values from two reports. the generated report should contain the 5 values of first report and last 5 values of second report. can any one guide me on this. pls... awaiting for the rply..

1 4883

1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.

FCS, IBM, Satyam, TCS,

5 27681

first of all i want say thanks to Zilanibasha, As u said that now these days Cirtification in cognos8 is only possible. Will u like to tell me in detail How i apply for cirtification As i m very much Interested.

1 4005

IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?

HP,

4 21008

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

HP, TCS,

6 19777

two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

HP, Patni,

10 25067

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?

HP,

3 12243

A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

HP,

5 16797

Three date formats are there . How to change these three into One format without using expression transformation ?

HP,

3 11781

What is exact difference between Parallel Jobs and server Jobs..

IBM,

7 20191

How can we run same job in 1 day 2 times

IBM,

4 18279

Wat is pre-load in Hashed file

Patni,

1 10136

How can we run same job in 1 day 2 times

IBM,

7 23471

What is exact difference between Parallel Jobs and server Jobs..

DELL, IBM,

8 60462

Un-Answered Questions { Data Warehouse }

how tokens will generate?

2210

Mention what is PROC in SAS?

1074

Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.

2004

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2163

what is data integration? : Sas-di

1133

What are aggregate transformation?

1048

Where do you see different stages in the designer?

1109

how many types of prompts are there? : Sas-bi

1090

What is data mapping and data modelling?

1565

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1062

What interface is used to connect to windows based applications?

1126

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1213

Have you used rollup component? Describe how.

1084

Is it possible to apply themes to microstrategy web? How?

947

What is Sequence clustering algorithm?

2037

For More Un-Answered { Data Warehouse } Questions Click Here