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

server hot-ws270 is connect to Repository B. What does it mean?

Cognizant,

2569

How do you do error handling in Informatica?

1 8074

How do you implement scheduling in Informatica?

1 3762

What is the meaning of up gradation of repository?

1994

How can you run a session without using server manager?

1 4381

Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?

2 4268

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2033

When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?

1 4000

What is the difference between normal and bulk loading? Which one is recommended?

1 5925

What is a test load?

1 4016

How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?

1 4773

What is the difference between a shortcut of an object and copy of an object? Compare them.

3 6622

What is mapplet and a reusable transformation?

2 5049

How do you implement configuration management in Informatica?

1 3749

What are Business Components in Informatica?

1 4983

Un-Answered Questions { Data Warehouse }

How can one identify whether mapping is correct or not without connecting session?

1457

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2346

what is the use of catlog or catlogfile?

2383

can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1383

What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?

952

Explain input and put function?

1147

where is the cache (lookup, index) created and how can you see it.

2017

explain about various caches available in data integrator? : Sas-di

1061

What is bteq script in teradata?

1162

What are the available join types in teradata?

1074

WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?

2801

What are the benefits of datastage?

1238

------------- How to identify the Revenue Column in Report?

2393

How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

2937

which date functions advances a date time or date/time value by a given interval? : Sas programming

970

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