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

Name 4 output files that informatica server creates during session running?

1 13616

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 15886

What are limitations of joiner transformation?

Exilant, TCS,

2 21229

can we generate reports in informatica ? How?

3 21872

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 7334

How can we eliminate duplicate rows from flatfile,explain?

3 11859

After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 7269

AT the max how many transformations and mapplets can we use in a mapping ?

Cap Gemini, Cognizant,

1 17307

What are slowly changing dimensions?

Informatica, Verinon Technology Solutions,

5 30847

What is the difference between OLTP and ODS?

4 27804

What is status code?

2 7135

What are the two modes of datamovement in informatica sever?

2 6993

What is confirmed dimension and fact?

7 19665

What are reusable transformations in how many ways we can create them?

2 9347

What is facttable granularity?

2 8251

Un-Answered Questions { Data Warehouse }

If a variable contains only numbers, can it be a character data type?

1087

Is redshift can be used with AWS RDS?

What is Fullouterjoin?

1983

Why do you need stage variables?

1181

What is primary and backup node?

1128

Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com

2321

What is the project in datastage?

1114

What is the meaning of decode in informatica?

1122

How can we acheive correlated sub-query in designer?can anyone help me in this regard?

947

What are the key features of chameleon that separates it from other algorithms?

1119

What is the difference between project backlog and product backlog?

1536

Name the command line functions to import and export the DS jobs?

1157

How to specify variables to be processed by the freq procedure?

1075

I'm busy writing a report that's using report bursting, to be able to do this I need to use a sequential section. Using a sequential section cause the grouping of the original report not to work. Please can someone give me advise on how to come past this problem, the report need to use grouping as it depend largely on totals ect, and I need to use a sequential section within the report to be able to use the report bursting facility.

2779

What is a deadlock and how it occurs?

1164

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