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

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 5874

i wanna some client names and project names in cognos? plz send cognos resumes(3+) exp plz plz plz help me??

TCS,

1 3476

plz plz plz send client names and project names in informatica?

1 5757

yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

iGate,

2 6822

how we can do session partition in informatica any one explain me clearly? thanks advance.

iGate,

1 6282

how to calculate EME version using unix ?

Accenture, IBM,

6 21989

1)How to bursting the cross tab report? 2)What is meant by Object explorer? 3)What is cascade report?

IBM,

1 7959

how to sort date field in infomatica?

2 6866

Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 4920

What is the usage propertys in Framework Manager?n Ie we set EMP ID as a Fact and what will happen?Actullay EMPID is a Identifier....

4 22189

Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga

2 4953

HOW TO DELETE A RECORD FROM FLAT FILE

TCS,

6 15729

Hi, difference between loop and trap in business objects ? Thanks in Advance nvsraghu

Infosys,

2 17499

I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)

3 7070

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2149

Un-Answered Questions { Data Warehouse }

Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

987

what type of raid setup would you put your tx logs?

940

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2182

How to generate sequence numbers?

1088

What are the differences between oltp and olap?

972

explain about unit testing? in real time?

2205

what is document design in boxi,have u participate in that

2184

How to load a Dimension ? and how to load a fact table?

1418

Why is it required to maintain a parent-child relationship among the various attributes? What are the various types of relationships depending on the number of participants?

1012

how to prepare the documentation in business objects and where to get the requirement?

2222

How do we resolve attribute roles in microstrategy?

1152

What is the difference between group and associare?

1048

Is there any difference in testing database and data ware housing?

2762

Different circumstance which drives informatica server to expel records?

983

What are the components of the report studio?

1178

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