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 3475

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

1 5754

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

iGate,

2 6819

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

iGate,

1 6280

how to calculate EME version using unix ?

Accenture, IBM,

6 21984

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 6862

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 22187

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 4952

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 17496

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 7068

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 framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

1013

What is write-back in obiee ?

833

Explain the main differences between star and snowflake schema?

979

Differentiate between sas functions and sas procedures.

1237

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?

3570

What are the differences between oltp and olap?

972

actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

1699

Differentiate between source qualifier and filter transformation?

1578

Explain the difference between oltp and olap?

1122

define junk dimension?

What if the source is a flat-file?

1110

In sas admin differentiate between roles and capabilities? : sas-grid-administration

1003

in the flow of data step processing, what is the first action in a typical data step? : Sas programming

1076

What is Redshift Spectrum?

Explain pmcmd command usage in informatica

1131

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