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

why we use stored procedure transformation?

IBM,

4 9222

how to limit number of rows in a report in business objects using webi?

Cap Gemini, TCS,

3 19975

HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com

FIS,

5 11181

while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance

MGL,

2 8040

If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?

Infotech,

5 10398

what are the roles and responsibilities of teradata DBA ?

TCS,

1 28231

what are the day to day activities of teradata DBA ?

TCS,

5865

what are the roles and responsibilities of BO Administrator ?

OCS Infotech, TCS, Wipro,

1 23504

what are the day to day activities of BO administrator ?

TCS,

3074

Why do we need Three environments Like DEV, UAT, PROD. Need detailed answer please

HCL,

1 12073

How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use

IBM,

6 31192

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 4409

What is the need of building a data warehouse?

2 4952

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

IBM,

1 4257

I need an oracle query for convert Char to Integer?. Can any one help me how to do this?

3 6651

Un-Answered Questions { Data Warehouse }

How will you do different types of narrative reports in obiee?

948

What is the difference between match merge and one to one merge?

1325

Can you define cognos powerplay?

1143

How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?

1308

Explain the special input delimiters used in sas programming.

1051

What is cognos reporting tool?

1145

Define datastores in cognos?

1002

where we cannot use sorter Transformation. if we use then we will not get correct data?

2253

How would you get two images on microstrategy login page?

1026

Name the various types of filters?

993

1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3641

Enlist the syntax rules followed in sas statements.

1135

What is difference between informatica power mart and power center?

1054

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1278

What are the different transaction levels available in transaction control transformation?

1280

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