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 tasks that source qualifier performs?

1 7006

What is the target load order?

HCL, Informatica,

3 13538

What is the default join that source qualifier provides?

Informatica,

3 14071

What are the basic needs to join two sources in a source qualifier?

4 13105

what is update strategy transformation ?

TCS,

7 24188

Describe two levels in which update strategy transformation sets?

1 9299

What is the default source option for update stratgey transformation?

1 7327

What is Datadriven?

Informatica,

2 8766

What are the options in the target session of update strategy transsformatioin?

2 10729

What are the types of maping wizards that r to be provided in Informatica?

2 8239

What are the types of maping in Getting Started Wizard?

1 5878

What are the mapings that we use for slowly changing dimension table?

2 10901

What are the different types of Type2 dimension maping?

1 5650

How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 8783

What are two types of processes that informatica runs the session?

2 19316

Un-Answered Questions { Data Warehouse }

How do we load data into Redshift?

Does Amazon redshift based on concept cluster?

What are dimensions?

1071

What are the data movement modes in informatica?

1166

What are differences between teradata and ansi session modes in teradata?

1176

How to fine tune mappings?

946

how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)

2702

Can you suggest us materials for sdtm mapping?

4451

If RDBMS is halted what will you do ?

2171

How sas treats the dsd delimiters?

1219

Why facts table is useful in representing the data?

1008

How can we use external procedural logic in informatica?

926

Is it possible to create multiple domains on a single Informatica server?

1248

What are normalization, first normal form, second normal form and third normal form?

1059

What are the primary characteristics of the Teradata.

1166

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