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

In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

5 10070

how do u move the code from development to production?

3 20361

Whrer u can save the Report net documentation in our local system?

1 5364

I need a help for Connecting to iServer Volume using IDAPI Classes(Java Classes) and after connecting to iServer i want to execute the ROX on iServer and also want know the status whether that job is succesfully run or not. Please do the needful if anyone of you known the code and send the copy of it ASAP.

3 7598

How do y read Sequential file from job control?

HP, IBM, Telesis,

2 15988

How do u call shellscript/Batch file from DS?

HP,

4 27108

What are the different database update actions available?

HP,

1 10227

Wat is isolation level and when do u use them?

HP, IBM,

1 21100

How do u view log file for a particular job?

HP,

6 25667

How do u set a default value to a column if the column value is NULL?

HP,

7 35801

How did you reconcile source with target?

HP,

2 11921

What modeling tool do you use?

HP,

6 13736

How did you reconcile source with target?

HP,

3 16943

Is it possible to join more than one universe in Business Objects? If its so how is that possible ? thanks in advance for the answers

Wipro,

5 18688

How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

iFlex, TCS,

2 9292

Un-Answered Questions { Data Warehouse }

What are the important features of datastage?

1144

Do we need an ETL tool? When do we go for the tools in the market?

986

Mention what is SAS data set?

1147

What are the differences between datamart vs. Reporting cube?

1112

In Teradata, what is the significance of UPSERT command?

1251

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2358

Why and when do you use proc sql?

1256

What is the basic syntax of a sas program?

1228

what are the filters in framework manager and report studio?

1006

-----------With out using DrillThrough how to do Reports?

2064

What is joiner change?

1159

What is partitioning? Explain different types of partitioning?

1259

how you provide security to reports? How you provide security to packages ?

1080

What is difference between page break and section report?

1224

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1737

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