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

any difference between cognos and real time cognos

2248

Does anybody have SAS Training manual or documentation or can you refer me any book to have better understanding on SAS. I am fresher to SAS tool. (Ready to pay)

4 5968

what is use of fload loading into set table?

IBM,

2 6549

what is a box type in cognos? what is a stitch query? what are the services that run in background when cognos is running

IBM,

2 11817

which option is used to restart the fast load script?

2 7255

what are the file sizes in your project?

2 6001

how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..

2161

write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?

IBM,

3 8144

If table have access lock.In the same table write lock is posible or not?

1 5500

teradata support to automatically increase the character length or not?

1 5433

I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

Wipro,

4 8679

Why should we use star schema in datawarehouse design?

Wipro,

2 6188

What is the difference between informatica 8.x and 9.x

Wipro,

1 12967

How to relege locks in fastload and multiload? example?

IBM,

4 23207

WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...

1 5026

Un-Answered Questions { Data Warehouse }

what is the difference between filter and condition?

1117

what is the use of proc sql? : Sas programming

1193

What are parallel querys and query hints?

2281

What versions of SAS have you used (on which platforms)?

1573

What is Data Caches size?

1130

What is the cumulative sum and moving sum?

1238

Highlight the points of differences between the database and user in Teradata.

1170

If you use a symput in a data step, when and where can you use the macro variable? : sas-macro

1139

What is repository manager?

1028

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1161

how much memory space occupied real time project (roughly)?

2289

Where $mpjret is used in ab-initio?

1199

What is orabulk stage?

1109

what make u disappointmnets in u r career

2266

What are fundamental stages of data warehousing?

1090

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