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

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2053

Why we use parameters instead of hard code in datastage.

IBM,

2 7678

How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

Infosys, TCS,

1 5711

How can we do null handling in sequential files?

Reliance,

3 17883

can we half project in parallel jobs and half project in server jobs?

Infosys, L&T,

4 10830

what are the different type of errors in datastage?

Wipro,

2 9086

30 jobs are running in unix.i want to find out my job.how to do this?Give me command?

3 9923

Can we use unconnected lookup as dynamic lookup?

TCL,

1 4128

Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?

5 8459

Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

2014

What is the difference between writing a joiner query in ANSI style and THETA style?

TCS,

2390

Why we select the table which has minimum number of records as Master table in joiner?

HG, UST,

4 19938

can we use mapplet as starting n ending object in mapping

TCS,

2 5818

what is the predefined port in dynamic lookup

2 6138

What is SAS? is it a software just for use or we can creat something over there?

Cognizant,

5 8991

Un-Answered Questions { Data Warehouse }

What is the difference between connected and unconnected stored procedures?

1092

what are the different views that are considered when building an object-oriented software system?

1039

What is difference between data mart and data warehouse?

985

What is dimensional table? Explain the different dimensions.

1179

How can we load the time dimension?

1206

What is fact degradation?

982

How can you import tables from a database?

1099

explain the methodology of Data Warehousing?(Polaries)

2029

How co> operating system natively processes the data?

1110

Difference between project merge and object manager?

1031

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1176

what type of graphs we will create(for 2+years candidates)?

2317

Are you involved in writing the inferential analysis plan? Tables specifications?

3973

list out all the transformations which use cache?

1191

What is the use of incremental aggregation? Explain me in brief with an example?

1031

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