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 4257

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

IBM,

3 10601

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

9 15224

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

1 8022

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

IBM,

5 11299

HOW CAN WE SEE THE DATA IN DATASET?

4 11172

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

2 5989

HOW CAN WE SEE THE DATA IN DATASET?

IBM, TCS,

12 58597

What are user classes?

HCL,

1 4066

What is conditional Formatting?

HCL,

2 7206

What are variable report studio?

HCL,

1 5495

What snowflake and Starschema?

HCL,

2 6076

How many fact tables you have in your project?

HCL,

1 4904

Where do you edit cognos sql in report studio?

HCL,

3 15022

what are burst options you have?

HCL, IBM, TCS,

2 8974

Un-Answered Questions { Data Warehouse }

Define joiner transformation?

1052

can anybody mail me the FAQS for hyperion essbase amd planning

5646

Describe routines in datastage? Enlist various types of routines.

1016

Explain functional dependency?

1092

what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake

2373

What is datastage?

1087

What do you mean by drill across?

1148

What are stage variables and constants?

1149

What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)

2138

What are the tasks that can be performed using sq?

1093

What are the types of data processing you are familiar with?

1217

To what type of programms have you used scratch macros?

2571

What is called partitioned primary index (ppi)?

1013

What are all the types of hierarchies?

1139

How to update or delete the rows in a target, which do not have key fields?

1180

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