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 8067

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

2 6264

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

IBM,

2 13789

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 4638

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 7518

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 5589

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,

1 3648

what happen if a query fail in dispatcher?

Cap Gemini,

1 8417

what is the structure of UV table in MLOAD?

Cap Gemini,

4 17440

what is DYNAMIC SQL in TD?

IBM,

1 6753

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 11777

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 17194

write lock is compatiable with which type of lock?

Infosys,

6 13015

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?

1 2100

Un-Answered Questions { Data Warehouse }

faq's on cognos

4108

How do you remove duplicate records in informatica? And how many ways are there to do it?

1224

What is dimensional table? Explain the different dimensions.

1262

Explain in detail about scd type 1 through mapping.

1641

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2298

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1026

hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com

2289

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

1167

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4788

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8274

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2054

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

2415

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2790

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1231

Are you involved in writing the inferential analysis plan? Tables specifications?

4011

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