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

How can you define user defied event?

1043

What do you mean by filter transformation?

963

Which files are created during the session rums by informatics server?

1194

What is the use of target designer?

1073

Briefly explain the aggregator transformation?

1024

What does update strategy mean, and what are the different option of it?

1107

What do you mean by worklet?

1084

What is predefined event?

1 1660

What is lookup transformation?

1055

How can one identify whether mapping is correct or not without connecting session?

1464

What are the different tools in workflow manager?

1 1983

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1105

What is the scenario which compels informatica server to reject files?

1088

Describe expression transformation?

1138

How union transformation is used?

1018

Un-Answered Questions { Data Warehouse }

How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?

1685

Differentiate input and infile.

1118

How do you start developing a datastage project?

1125

how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.

879

What are different types of joins that are possible in obiee rpd?

852

Explain teradata architecture in detail with a diagram.

1135

Your application mode has crashed. How would you run your i-server?

998

Does redshift support unstructured data?

What do you know about partition and also tell us about partition components in abinitio?

1068

what are informats in sas? : Sas-administrator

1106

What are the different softwares used with their functions in teradata?

1031

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

1006

What are the five ways to do a table lookup in sas? : sas-grid-administration

1078

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

1400

Explain meta data?

1043

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