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 are the steps involved in the migration from older version to newer version of Informatica Server?

1 2174

What are the main features of Oracle 8i with context to datawarehouse?

1 2180

What are the new features of Power Center 5.0?

1 1882

How to run a session, which contains mapplet?

1 4088

Differentiate between Load Manager and DTM?

1 2263

What are session parameters ? How do you set them?

1 1921

When do you use mapping parameters? (In which transformations)

1 4138

What is a parameter When and where do you them when does the value will be created

1911

Design time, run time. If you don't create parameter what will happen

1 1907

What are variable ports and list two situations when they can be used?

1 3015

What are the parts of Informatica Server?

Cognizant,

1 3594

How does the server recognize the source and target databases. Elaborate on this.

1 4165

List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 3671

What is the difference between sequential batch and concurrent batch and which is recommended and why?

1 3573

A session S_MAP1 is in Repository A. While running the session error message has displayed

1 3402

Un-Answered Questions { Data Warehouse }

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2550

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6079

1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

4265

Explain scd type 3 through mapping.

1076

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1853

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

1144

explain in detail about type 3?

1091

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3447

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1212

What is dimensional table?

1168

Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2153

Hi, If anyone has base SAS certification dumps, please share.

1941

what are the dimensions that you have in your current project?list them?

2095

Demonstrate experience in maintaining quality process standards?

2676

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3666

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