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 anyone need COGNOS 8 Certification Dumps of any "COG - Code", u can get from S_Cog@Yahoo.Com, i scored 100 % with these Dumps

1 4341

What is render variable?Where do you exactly use in developing a report?

IBM,

3 10737

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?

9 15448

by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?

1 8109

at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it

IBM,

5 11484

HOW CAN WE SEE THE DATA IN DATASET?

4 11307

CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?

2 6096

HOW CAN WE SEE THE DATA IN DATASET?

IBM, TCS,

12 59063

What are user classes?

HCL,

1 4141

What is conditional Formatting?

HCL,

2 7313

What are variable report studio?

HCL,

1 5575

What snowflake and Starschema?

HCL,

2 6193

How many fact tables you have in your project?

HCL,

1 4981

Where do you edit cognos sql in report studio?

HCL,

3 15159

what are burst options you have?

HCL, IBM, TCS,

2 9066

Un-Answered Questions { Data Warehouse }

What is spool space? Why do you get spool space errors?

1088

What is level metrics in microstrategy?

1121

What happens in a conflict? How do you handle that?

1105

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1734

What is SAS? What are the functions does it performs?

1250

what is the primary data source for the wrs? : Sas-bi

1344

what is sas olap server? : Sas-di

1302

What are the join problems comes appart from loop,chasm & fan Traps

2192

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1928

What are the different softwares used with their functions in teradata?

1066

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2193

what is the use of server manager?

2200

Approximately what date is represented by the SAS date value of 730?

1276

what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)

2142

Explain difference between view and materialized view?

1023

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