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

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1 1170

What are the various indexes in teradata? How to use them?

1 1085

How do you design aggregate tables using teradata?

1 1853

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

1 1113

What are the various indexes in teradata? Why are they preferred?

1 1079

Explain teradata utilities. What is multiload, fast load, tpump?

1 1066

What are aggregate tables? How do you design them using teradata?

1 1248

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

1 1124

What are default access rights in teradata? What explicit right can be given to a user?

1 1157

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

1 1064

What are the various indexes in teradata?

1 1120

Explain teradata architecture in detail with a diagram.

1 1179

How would you load a very large file in teradata in general?

1 1104

Why do you get spool space errors? How do trouble-shoot them?

1 1109

Explain and compare pros and cons of snow flake schemas?

1 1106

Un-Answered Questions { Data Warehouse }

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4796

Explain scd type 3 through mapping.

1071

What is dimensional table?

1162

How to create the source and target database connections in server manager?

1144

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1670

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1176

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1100

Explain about a time when you discovered a more efficient way to do a work task?

1222

Write the unconnected lookup syntax and how to return more than one column.

1174

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2311

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1200

Are you involved in writing the inferential analysis plan? Tables specifications?

4019

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2766

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1196

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2259

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