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

Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are wrong format it is going to error table but i don't want load error table if any wrong format in Date column Pass "NULL" how can we do it fast load

4 8063

I have 4 tables having many to many relationships between the tables? How i can get correct results in the report?

2 6262

How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?

IBM,

2 13780

hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help

1 4636

while developing a report in BO i had created prompts at query level? When an end user runs the report he has to see the details of the report with out entering the prompt values? How can we do this in BO?

PWC,

2 7515

Hi, In BO at universe designer i had four tables which has many to many relationships between the tables. How to fetch the correct results in the report?

TCS,

2 5585

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?

PWC,

3642

what happen if a query fail in dispatcher?

Cap Gemini,

1 8415

what is the structure of UV table in MLOAD?

Cap Gemini,

4 17436

what is DYNAMIC SQL in TD?

IBM,

1 6752

what is a multi statement request in TD? what is the diif b/w V2R5 & TD12? what is the diff b/w MACRO & STORED PROCEDURE?

HCL,

3 11772

in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?

HCL,

2 17190

write lock is compatiable with which type of lock?

Infosys,

6 13003

i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 5008

what is SDLC way of code development?

2100

Un-Answered Questions { Data Warehouse }

Explain how many types of dimensions are available in informatica?

1182

I need to set predefined condition. How I do this?

1070

how can you import .csv file in to sas? : Sas programming

1150

Enlist various types of routines in datastage.

1339

Explain why denormalization is promoted in universe designing?

1006

How you Implemented SCD Type 1 & Type 2 in your project?

4184

Which version configuration tool used in ur project?

3329

Explain md doctor?

1030

What do you understand by a cartesian join?

1171

what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

1161

Can you run multiple rpd’s in a single obiee instance?

845

What is teradata? Also, list out some of the primary characteristics of teradata.

1145

what are the other factors of the database on which the loading performance depend?

1961

Explain the data type of the surrogate key?

1000

Describe the main features of datastage?

1139

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