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 session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

HeadStrong, TCS,

8 31193

What are the different types of schemas?

ITC Infotech,

11 87192

How to enter same record twice in the target table,explain?

7 14000

What are the different threads in DTM process?

2 9895

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 12774

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 35486

what are presession,postsession success and postsession failure commands ?

1 6801

What are mapping parametres and variables in informatica?

TCS,

6 35657

Give me a broad concept of what a data warehouse is, and what it might be used for?

2 5203

What is a Data Cube?

1 6328

Explain in simple terms, the concept of Data Mining.

3 12945

how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

iGate,

2138

which automation tool is used in data warehouse testing?

1 6332

what is data validation strategies for data mart validation after loading process

1 6864

what is the difference between etl tool and olap tools

3 10748

Un-Answered Questions { Data Warehouse }

hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?

2121

What are the benefits of data processing according to you?

1216

What is the use of AWS redshift driver?

hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file

2370

Write the components microstrategy metadata?

1031

What is zero-foot print?

1019

What are the components of report net?

1268

How to do unit testing in informatica?

1173

What is the use of datastage designer?

1155

What are modeling tools available in the market?

978

What is informatica? Why do we need it?

1101

What is the function of Stop statement in a SAS Program?

1153

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2262

What do you code to create a macro? : sas-macro

1142

Describe the between keyword in teradata?

1040

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