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 6034

Order of Evaluation of Parameters

2 13327

How to convert RGB Value to Hexadecimal values in datastage?

3997

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 9097

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 11043

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 9679

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

IBM,

2 6672

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 7130

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

4 7889

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 6189

/* 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 7550

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

CTS, TCS,

1 6466

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 }

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2230

What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

4583

Have you worked with packages?

1212

What are the databases that informatica can connect to windows?

1052

In how many ways we can create ports?

1123

What is the Process to creating lookup transformation in informatica

1044

How do you handle two sessions in Informatica

1164

What are the differences between sum function and using “+” operator?

1108

How complex jobs are implemented in datstage to improve performance?

1042

how to perform single sign in cognos by using url?

1154

How a server job can be converted to a parallel job?

1094

What is the function of look up transformation?

1123

What are types of batch available in cognos?

974

What do you mean by drill across?

1148

what r the job openings SAS for fresher graduates !

2457

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