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 if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 1541

What is common among data validity and data integrity?

1109

Do you think effective communication is necessary for data processing? What is your strength in terms of same?

1196

Do you know what a local lookup is?

1270

What are the types of data processing you are familiar with?

1258

What is the difference between look-up file and look-up, with a relevant example?

1247

What exactly do you know about the typical data analysis?

1154

What are the different forms of output that can be obtained after processing of data?

1301

What is broadcasting and replicate?

1224

What do you mean by a transaction file and how it is different from that of a sort file?

1101

Suppose we assign you a new project. What would be your initial point and the key steps that you follow?

1226

Have you worked with packages?

1275

How do you add default rules in the transformer?

1228

Within a cursor, how would you update fields on the row just fetched?

1127

How to create a repository in abinitio for stand-alone system(local nt)?

1180

Un-Answered Questions { Data Warehouse }

What is sorter transformation?

1111

What do you mean by drill through report?

1019

How do you see a ddl for an existing table?

1063

Explain what is the difference between a primary and secondary actor in use case modeling?

1122

What are the different types of security you have worked in obiee?

834

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1135

What is connection profile? : sas-grid-administration

1235

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1128

Where the applications and where ware house management system is used?

1059

When we save a report in report studio with what extn it save?

1104

What do you mean incremental aggregation?

1131

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?

1559

How to improve session performance in aggregator transformation?

1032

what make u disappointmnets in u r career

2266

What you know about transaction control transformation?

1062

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