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 11327

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 6637

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 21334

If RDBMS is halted what will you do ?

Teradata,

2231

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

Teradata,

1 5138

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

Teradata,

2462

Give some points about Teradata Viewpoint ?

Teradata,

3 13665

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

1987

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

2249

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

2232

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

3 6767

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

2105

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

2007

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

1 4644

Un-Answered Questions { Data Warehouse }

tell me 5 session failure in real time how can you solve that in your project?

2406

Explain the difference between holap and rolap?

1032

Distinguish between informatica & datastage. Which one would you choose and why?

1060

How to use pmcmd utility command?

1080

Explain Teradata performance tuning and optimization?

1229

What is slibref?

1343

-----------Diff b/w OLAP and RDBMS?

2115

Where we use afc in actuate?

1097

What is latest version of power center / power mart?

1156

What is SAS informats?

1169

Explain fact structure?

1029

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1146

I generated one report design time I can color green. At run I want bule how to change dynamically? And which method I can over write?

1047

What is a partition and what are the different types of partition components in abinitio?

1315

If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

1078

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