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 7821

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

2 6168

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

IBM,

2 13686

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 4542

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 7420

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 5502

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,

3589

what happen if a query fail in dispatcher?

Cap Gemini,

1 8341

what is the structure of UV table in MLOAD?

Cap Gemini,

4 17305

what is DYNAMIC SQL in TD?

IBM,

1 6671

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 11639

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 17050

write lock is compatiable with which type of lock?

Infosys,

6 12821

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 4926

what is SDLC way of code development?

2050

Un-Answered Questions { Data Warehouse }

How do you change a non-reusable transformation to reusable transformation?

1009

How would you get two images on microstrategy login page?

997

hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

2065

What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

1083

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1219

How is possible this scenario using in type-in prompt.?

1065

How to load data in informatica ?

1033

Explain oject manager?

1016

What is the multi-insert?

1048

what is log in cognos?

1213

Difference between informatica vs ab initio?

1328

explain about data integrator metadata reports? : Sas-di

1119

What are the differences between datastage and informatica?

1191

What are the steps to build the datawarehouse?

1050

What is mapping debugger?

1027

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