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 11150

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 6516

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

GalaxE,

2316

what is the difference between ab_work_dir and .work

TCS,

2 21202

If RDBMS is halted what will you do ?

Teradata,

2182

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

Teradata,

1 5072

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

Teradata,

2422

Give some points about Teradata Viewpoint ?

Teradata,

3 13528

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

1957

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

2212

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

2181

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

3 6628

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

2058

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

1963

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

1 4567

Un-Answered Questions { Data Warehouse }

How would you copy the content of one repository to another repository?

1036

What is a standalone command task?

1217

Difference between project merge and object manager?

1032

Can you fastexport a field, which is primary key by putting equality on that key?

1191

r u done any partitions in ur project?

1840

What data formats does Redshift Spectrum support?

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

2168

Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

1075

what is sas metadata server? : Sas-di

1117

Your application mode has crashed. How would you run your i-server?

998

What are the various ways of incorporating security in microstrategy?

1024

without table how to come first record only in oracle?

2268

Can you define a query subject?

1027

Code check-in and check-out commands in AbInitio

4326

can we perform checkin and checkout through sandbox?

1193

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