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

Explain briefly scd type2 in datastage7.5x2(parallel)

IBM,

1 6030

Order of Evaluation of Parameters

2 13326

How to convert RGB Value to Hexadecimal values in datastage?

3996

i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

Satyam,

3 9096

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

iGate,

7 11042

I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 9031

SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS

1 5551

source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235

US Technology,

6 9677

how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer

IBM,

2 6670

one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?

IBM,

3 7124

solve the following loops? dimension table fact table fact table dimension table link will be there between tables?

4 7887

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

2 6188

/* To determine the maximum and minimum of V1 */ data before3; input v1 v2 v3; cards; 3 2 1 4 6 5 2 1 3 6 5 4 1 3 2 5 4 6 ; run;

5 7544

What are steps to follow Informatica migration from 7x to 8x? Pls Explain...

CTS, TCS,

1 6464

What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)

2138

Un-Answered Questions { Data Warehouse }

What do the PUT and INPUT functions do?

1336

Difference between PowerPlay transformer and power play reports?

2517

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2493

Can you explain a cognos controller?

1020

Can you define materialized view?

1045

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2237

differentiate between view and materialized view?

Can you define framework manager?

1028

how the sas basic syntax style described? : Sas-administrator

1019

How do you specify the number of iterations and specific condition within a single do loop?

1103

What could be a data source system?

1008

Differentiate between operational datastage (ods) and data warehouse?

1178

Explain the pipeline partition with real time example?

1143

Explain is it the job of a business analyst or systems analyst to draw the class diagram?

1037

In SAS explain which statement does not perform automatic conversions in comparisons?

1312

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