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

How do we call shell scripts from informatica?

1135

Where do we use mapping variables in informatica?

1083

How can we use mapping variables in informatica?

1078

How can we use mapping variables in informatica? Where do we use them?

1219

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1090

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1043

Difference between nodup and nodupkey options?

1206

Explain bmdp procedure?

1048

What makes sas stand out to be the best over other data analytics tools?

1084

What will calendar procedure do?

1088

Do you know the features of sas?

1056

How to convert a numeric variable to a character variable?

1219

Explain translate function?

1218

What is program data vector (pdv)?

1304

Explain by-group processing?

1006

Un-Answered Questions { Data Warehouse }

Do you view contain data?

953

how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

2429

What is the purpose of having stored procedures in a database?

1181

How did you plan your Data ware house project?

2320

differentiate between power play transformer and power play reports?

What is meta data and system catalog?

2312

What the difference between “look-up” file and “look is up” in abinitio?

1372

What are the approaches used by optimizer during execution plan?

921

What is called a slice?

1039

Explain the difference between etl tool and olap tools?

927

How to a create header dynamically in a crosstab report in cognos 8.1?

2449

What are all the problems you faced while validating tables and reports?

3488

Quickly characterize reusable change?

1134

How do you truncate a table?

1184

What are the various file formats involved in reportnet?

999

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