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 to return multiple columes through through un-connect lookup?

DELL,

1 6984

explain one complex mapping with logic? sales project?

Accenture, JPMorgan Chase,

6670

Performance tuning in UNIX for informatica mappings?

CGI, CTC,

2568

How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 3050

How to do the error handling of if ur source is flatfiles?

1968

In ur current projectu have done any performance tuning of mappings?

1 4629

In which scenario did you used pushdown optimization?

1 3317

In which scenario did u used Mapping variable?

Cognizant,

1 2703

In Which scenario did u used Incremental loading?

2 6189

Did u used latest transformations of 8.6.0? for what?

1882

When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 7605

what is semi-additive fact?where did u used?

2 5402

I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 3947

In dimension and fact table? which one holds big data?

2 6458

my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?

ACS,

3 7794

Un-Answered Questions { Data Warehouse }

What are different table types used in teradata?

1044

how do u really know that paging to disk is happening while u are using a lookup transform?

2428

What is a fact, dimension, measure?

1209

Define the slice and dice?

1011

What is scanmd and md doctor?

1067

Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

975

explain the key concept of sas? : Sas-administrator

1007

How many tables can you join in v2r5?

1073

Explain what is fact less fact table? Where you have used it in your project?

933

What you mean by drill across and what is the difference between drill through, drill across?

1028

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2182

What is the difference between the standard and metrics folder?

971

How to generate cubes in cognos?

974

Describe stream connector?

1307

Explain piconet?

963

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