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 if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 1494

What is common among data validity and data integrity?

1074

Do you think effective communication is necessary for data processing? What is your strength in terms of same?

1153

Do you know what a local lookup is?

1219

What are the types of data processing you are familiar with?

1225

What is the difference between look-up file and look-up, with a relevant example?

1206

What exactly do you know about the typical data analysis?

1119

What are the different forms of output that can be obtained after processing of data?

1264

What is broadcasting and replicate?

1181

What do you mean by a transaction file and how it is different from that of a sort file?

1055

Suppose we assign you a new project. What would be your initial point and the key steps that you follow?

1146

Have you worked with packages?

1224

How do you add default rules in the transformer?

1191

Within a cursor, how would you update fields on the row just fetched?

1083

How to create a repository in abinitio for stand-alone system(local nt)?

1137

Un-Answered Questions { Data Warehouse }

How can we improve performance of data stage jobs?

1027

How is MLOAD Teradata Server restarted after execution?

1275

describe about metadata object? : Sas-di

1087

What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

1017

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.

1180

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

2143

How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4731

What are the various reporting tools in the market?

1079

Can you execute macro within another macro? : sas-macro

1008

Explain difference between e-r modeling and dimentional modeling?

997

How many ways to overcome a missing values???

2825

Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3852

What does command task mean?

1161

What is flashback table ? Advance thanks

1954

what do u do when DB time takes more?in sap bi

2212

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