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

what is the use of server manager?

2153

A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

2243

how do u implement scheduling in Informatica?

Cognizant,

1 7833

what is the meaning of upgradation of Repository?

IBM,

3764

what is the indicator file and where it is used?

1 5077

1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

2136

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

3781

when u connect the 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?

2192

what is the difference between normal & bulk loading? and which one is recommended ? why?

2 6797

what is a test load?

3 16805

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

2290

what is the difference between shortcut of an object and copy of an object? compare them?

1 6221

how do u implement configuration management in Informatica?

4805

what are business components in Informatica?

2 11190

dimension object created in oracle can be imported in designer?how?

3003

Un-Answered Questions { Data Warehouse }

Could any one explain me how to create cascading prompts?

1090

what is the use of proc contents and proc print in sas? : Sas-administrator

1074

How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

966

Explain what are the measure objects?

1008

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1526

Explain what is a view as it relates to system modeling?

1006

What are various etl tools in the market?

1028

Why filter transformation is an active one?

997

how to perform single sign in cognos by using url?

1166

What is afc?

990

What is the basic syntax of a sas program?

1230

How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on

1006

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1924

Define Data Warehousing?

1165

Explain the data type of the surrogate key?

962

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