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

I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?

Cap Gemini,

6 14181

please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??

2102

1)How to Duplicate Records Delete in Sequential file?

IBM, TCS,

4 15192

can we join volatile table with general table an global temporary table with general table ?

IBM,

4 10190

how to restrict up to three levels in hierarchy when u do drill mode?

iGate,

3 8240

what are the tables used in health care domain project and columns used in report?

IBM,

4512

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1772

if we shortcut join between two tables what will be the output?that it will give all columns or same columns?

2 5355

In the following DATA step, what is needed for ‘fraction’ to print to the log? data _null_; x=1/3; if x=.3333 then put ‘fraction’; run;

1 7207

How is Teradata in current market?

4 8836

What are the issues you have faced in your project? How did you overcome those issues?

CTS, FEEE, TCS,

2365

How to create a report template BO XI R2

Infosys, LBM,

2 9179

From where you extract the data, how you did it into informatica? explain....

Accenture, Unisoft Infotech,

1 6091

What are your source in project and how you import in informatica? How can i explain abt this?

Accenture, Unisoft Infotech,

1 6498

What are events in workflow manager?

Accenture, IBM,

1 8827

Un-Answered Questions { Data Warehouse }

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2277

What is the basic structure of a sas program?

1120

Explain what is the main difference between inmon and kimball philosophies of data warehousing?

986

What is the difference between Data Warehousing and Data Mining?

1055

Is olap services sold as a separate product?

921

What sas features do you use to check errors and data validation?

1220

Which sql query platform are you using to communicate with redshift?

What do you understand by a cartesian join?

1117

Explain ibm infosphere information server and highlight its main features?

1091

What is informatica worklet?

1067

How can sas program be validated?

1036

What are the differences between different versions of co-op?

1004

What is Sequence clustering algorithm?

2024

Explain the term 'database' related to relational database management system?

984

SCD2 will work on only dimension tables as well as fact Table?

1401

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