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 7787

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

2 6144

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

IBM,

2 13666

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 4528

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 7398

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 5474

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,

3570

what happen if a query fail in dispatcher?

Cap Gemini,

1 8328

what is the structure of UV table in MLOAD?

Cap Gemini,

4 17272

what is DYNAMIC SQL in TD?

IBM,

1 6648

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 11602

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 17017

write lock is compatiable with which type of lock?

Infosys,

6 12782

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 4907

what is SDLC way of code development?

2042

Un-Answered Questions { Data Warehouse }

What is the difference between nodupkey and nodup options?

1038

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1796

What is a pre-defined event and user-defined event?

1037

Differentiate between reusable transformation and mapplet.

1094

Does microstrategy web support clustering via cisco local router or any other third-party clustering software?

984

Explain the difference between powerplay transformer and power play reports?

1023

This entry was posted in General. Bookmark the permalink. Post a comment or leave

4575

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2136

how we can load rejected record's at run time?(not through bad files)

2379

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1953

What is type 2 version dimension?

974

What is node? How many nodes and amps used in your previous project?

1110

Why sorter is an active transformation?

1191

Differentiate between hash file and sequential file?

1072

What are the difference between sas functions and procedures?

1155

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