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

Suppose you find the term validation mentioned with a set of data, what does that simply represent?

985

What do you mean by the overflow errors?

1309

What are the factors on which storage of data depends?

1101

What kind of layouts does abinitio support?

1202

List out the file extensions used in abinitio?

1048

What are the different types of parallelism used in abinitio?

1046

Explain how abinitio eme is segregated?

1434

We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?

1383

How to run a graph infinitely?

1072

What are the benefits of data processing according to you?

1169

What is expression transformation?

1040

What are the different lookup cache(s)?

1037

In informatica workflow manager, how many repositories can be created?

1278

In informatics server which files are created during the session rums?

1070

How are indexes created after completing the load process?

1550

Un-Answered Questions { Data Warehouse }

Define metrics studio?

981

hi,can you please share with me about,what is reportlimit,report order and how can create and use

5177

What is a grid in Informatica?

1003

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

2000

I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

2222

What are the difficulties u faced while doing vital signs table or dataset?

2343

What are the data types that sas contain?

1124

Name some categories in sas 9? : sas-grid-administration

917

Explain how you can run a graph infinitely in ab initio?

1055

The question was on time stamp. what is the difference between HH and HH24 when to use when.

1999

what is parallel query?

2030

what are the functions required to be called for enabling or disabling the bulk load of mode?

Explain in detail abt measure objects? And what is the use of it? How to create it?

943

how do you create schema objects in 2 tier connection?

886

Differences between where and if statement?

1027

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