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

i have a table like sales....the field are Prodid Jan(jam month sales)Feb March apr may jun july 1 20 76 50 74 94 93 83 2 30 94 40 94 93 93 02 3 40 90 30 49 94 92 56 4 70 20 30 93 46 35 78 5 23 40 40 39 84 46 57 6 85 30 55 93 46 46 46 7 84 20 65 83 56 57 57 8 10 93 40 93 68 57 36 9 57 30 30 83 67 57 79 10 38 83 40 83 55 68 47 11 35 39 90 94 57 78 47 12 83 89 50 93 79 69 69 i wat ti find the max sales of every product which i want to load into target table

Satyam,

6 11304

Frnds.... i have one doubt we have the num like this +913757575......i want to remove 91 and i want lo load remaining data to the target table.. whinch function we can use in teradata????? Plz let me know.. thanks in advance

2 6622

can you tell me what are the dimension tables are used in project

GalaxE,

2367

what is the difference between ab_work_dir and .work

TCS,

2 21319

If RDBMS is halted what will you do ?

Teradata,

2225

If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?

Teradata,

1 5129

If a Node is busy what are the steps you can take to avoid ?

Teradata,

2459

Give some points about Teradata Viewpoint ?

Teradata,

3 13650

how do you manage the production space. what are the proactive methods you can take ?

1983

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2245

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2226

If the table does not have duplicates then which utility you can suggest to load the data ?

3 6753

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

2099

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

2004

A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?

1 4640

Un-Answered Questions { Data Warehouse }

What is difference between e-r modeling and dimensional modeling?

974

what is the difference steps for data modeling?

2211

How are the sources and targets definitions imported in informatica designer?

1176

What is an enterprise?

1112

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

1258

What is lookup transformation?

1100

What is etl process. How many steps etl contains explain with example?

1007

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1968

how many types of viewers available in tm1?

Explain about a task that really tested your analytical abilities?

1311

What is the difference between in process and inter process?

1205

Explain what is the difference between native sql and cognos sql?

1056

explain about various caches available in data integrator? : Sas-di

1121

Explain 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?

1063

What is a rank transform?

1150

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