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?

2057

Why we use parameters instead of hard code in datastage.

IBM,

2 7687

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 5716

How can we do null handling in sequential files?

Reliance,

3 17893

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

Infosys, L&T,

4 10841

what are the different type of errors in datastage?

Wipro,

2 9095

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

3 9935

Can we use unconnected lookup as dynamic lookup?

TCL,

1 4135

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 8468

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

2019

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

TCS,

2394

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

HG, UST,

4 19947

can we use mapplet as starting n ending object in mapping

TCS,

2 5828

what is the predefined port in dynamic lookup

2 6150

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

Cognizant,

5 9001

Un-Answered Questions { Data Warehouse }

what is a security filter?

1015

name several ways to achieve efficiency in your program? : Sas programming

1088

What are the design methods of data warehousing?

964

What are the different options available for update strategy?

1010

Explain the use lookup tables and Aggregate tables?

990

Explain what are the different types of transformation available in informatica.

1169

What is a Folder?

1192

How one source columns or rows to be loaded in to two different tables?

1144

Explain input and put function?

1154

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2253

What's the difference between timestamp (0) and timestamp (6)?

1209

Differentiate primary key and partition key?

1001

What is crass reference table?

1070

Can you explain the advantage of using shortcuts?

1045

How to elaborate tracing level?

1193

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