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

2207

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 5820

what is use of fload loading into set table?

IBM,

2 6446

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 11718

which option is used to restart the fast load script?

2 7158

what are the file sizes in your project?

2 5924

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..

2114

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

IBM,

3 7988

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

1 5417

teradata support to automatically increase the character length or not?

1 5355

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 8535

Why should we use star schema in datawarehouse design?

Wipro,

2 6095

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

Wipro,

1 12865

How to relege locks in fastload and multiload? example?

IBM,

4 23021

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 4939

Un-Answered Questions { Data Warehouse }

Mention a few of the ETL tools that come under Teradata.

1081

What is the order of precedence of vldb properties?

1011

What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

5651

What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.

997

What is rank transformation in informatica

1180

Which is the t/r that builts only single cache memory?

1190

how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

2539

What is the difference between the local container and shared container?

1108

how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

1041

differentiate between two-tier, three-tier and four-tier connections.

995

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1958

What is a Transformer?

1079

How do you define data block size?

1055

Explain why are oltp database designs not generally a good idea for a data warehouse?

1033

Mention what are the data types does SAS contain?

1155

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