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 do you understand by SOA of Informatica?

1050

How to open an older version of an object in the workspace?

1273

How to start a workflow using pmcmd command?

1309

What is resilience time?

1229

What are the themes in a data warehouse?

1100

How we check the errors before running the report?

1041

What is the advantage of using shortcuts?

1253

How to select multiple values from type-in prompt?

1109

What r the names of the reports that you prepared?

1023

How to pass parameter value into html design page?

1 1646

Which studio is used to create reports?

1159

How is possible this scenario using in type-in prompt.?

1103

What is the difference between Standard and Metrics folder?

1129

What is the difference between a cascading report and drill through report?

1124

What are initial page components of Cognos connection?

1050

Un-Answered Questions { Data Warehouse }

describe the interaction table in sas di? : Sas-di

1081

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

4241

what type of raid setup would you put your tx logs?

1001

What are the various indexes in teradata?

1108

How would you identify a macro variable? : sas-macro

1066

AGGREGATOR default datatype

1528

How would you invoke a macro? : sas-macro

1192

What are orabulk and bcp stages?

1167

What is the difference in creating filters in designer and business objects?

1086

How to export mappings to the production environment?

956

what are the devoleper roles in real time? plz tell i am new to datastage....

2217

Explain and compare pros and cons of snow flake schemas?

1093

What are some commonly used bteq scripts?

1065

What is etl process?

983

What are some examples of informatica etl programs?

993

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