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

in reporting we add some new objects,how we get the count of the newly added objects to the report

HP,

2205

Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2410

plz tell me about BOmain key in detail?

2 7612

tell me about aggregate awareness in detail?

Cap Gemini,

2 22293

what is the difference between enterprise data warehouse and data warehouse

4 18829

what is symmetric key?where do u use this?

1 11421

is there any difference between operational database and data base?if yes what r they?

2082

plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........

2362

What is TRAP in Framework manager?What's the use of TRAP? Where We are using this?

HCL, TCS,

2 20885

What's the differance between each studio in cognos 8?

TCS,

1 5777

How to convert the tabular report into graphical report?Is this possible in cognos 8 report studio?

IBM, TCS,

3 7501

What is the difference between regular dimension and derminant?

TCS,

2286

i need help from u. i want to learn abinitio. please provide pdfs or material or books.

iGate, TCS,

56 67619

If any one Deleted the BOMain key by accidently,is any possible to get back that Bomain key.if possible please send some steps.

iFlex, Pfizer,

2 8576

what is merged imension in 6.5 and webi

1 4577

Un-Answered Questions { Data Warehouse }

What are the functions of a Parser?

1126

Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?

1080

If RDBMS is halted what will you do ?

2182

Describe the between keyword in teradata?

1048

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4387

Explain reference cursor?

2173

What is meant by lookup transformation?

1127

please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??

2111

What is the command in bteq to check for session settings ?

1192

What is a grid in Informatica?

1084

How to sort in descending order?

1272

Difference between server jobs & parallel jobs?

1092

Explain me what are conformed dimensions?

1048

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1678

How to generate sequence numbers using expression transformation?

1103

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