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 1490

What is common among data validity and data integrity?

1069

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?

1217

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

1220

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

1204

What exactly do you know about the typical data analysis?

1116

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

1260

What is broadcasting and replicate?

1178

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

1051

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

1143

Have you worked with packages?

1224

How do you add default rules in the transformer?

1190

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

1080

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

1133

Un-Answered Questions { Data Warehouse }

Explain what does level of granularity of a fact table signify?

961

Explain the difference between dw and bi?

1056

Performance tuning in UNIX for informatica mappings?

2575

suppose the network connection between a webserver and clustered i-server gets lost. What will happen? Will the report still run?

985

What is amazon redshift odbc?

What do you mean by the term data warehousing? Is it different from data mining?

1224

what is the use of surogate key in datastage

2312

How will you monitor the errors received while running i-server and report?

954

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1997

what is information maps?

2231

Explain what are the advantages data mining over traditional approaches?

1169

What is an enterprise?

1057

To import the flat file definition into the designer where should the flat file be placed?

1066

How do you Parametermap variables in Quiries?

2274

Why do you think data processing is important?

1140

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