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 11120

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 6500

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

GalaxE,

2303

what is the difference between ab_work_dir and .work

TCS,

2 21174

If RDBMS is halted what will you do ?

Teradata,

2168

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

Teradata,

1 5056

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

Teradata,

2414

Give some points about Teradata Viewpoint ?

Teradata,

3 13498

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

1945

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

2204

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

2163

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

3 6603

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

2048

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

1955

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

1 4554

Un-Answered Questions { Data Warehouse }

What is prompt types of prompts?use of prompts syntax of prompt?

1344

Mention a few design and development best practices for informatica?

997

How do you set a varible in incremental aggregation

1891

For what purposes have you used sas macros? : sas-macro

1001

How to get sql from obiee for reports?

885

Compare sas with other data analytics tools.

1034

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2149

How an expression transformation differs from aggregator transformation?

1043

What do you understand by the cognos?

977

In general, how do you optimze any sql in teradata?

1042

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

1205

What is the difference between in process and inter process?

1147

what are the different types of tests done on a microstrategy report?

896

Compare aggregates and data marts

2765

how would u estimate the size of Aggregator transform data and index cache?

2413

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