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 is the size of u r project? and what is the size of source file?

HP,

1 5928

what is the size of u r source(like file or table)?

HP,

2282

my source is junk data how will u remove that junk data by using unix please any one replay me

Cap Gemini,

3713

how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me

Cap Gemini, IBM,

16 25479

explan ur project architecture?

TCS,

2079

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?

TCS,

3 10062

i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 12765

How can you change from reusable session into non-reusable session.

Cap Gemini,

5 42626

every alternative row should be hilighted ? how u can ?

1 5582

why we are using derived tables ?how it will help?

2 6160

how u restrict the values?to display 5 values insted of 10 values?

4 8051

what is mean by lov?

4 10323

limitaions of cross tab ?

1 5985

write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

TCS,

8 10027

I want load the data into target with out 1st and last record.

Yash Technologies,

5 10030

Un-Answered Questions { Data Warehouse }

Explain fastload in teradata?

1120

After the complete generation of a report who will test the report and who will analyze it?

990

What is the use of Cognos scenario?

1202

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2492

What is a bridge table ?

897

how can you create zero observation dataset? : Sas programming

1164

What are the advantages of using informatica as an etl tool over teradata?

1035

Differentiate between a repository server and a powerhouse?

1131

what do you mean by security filter?

1013

How does a rank transform differ from aggregator transform functions max and min?

1219

Start a batches with in a batch?

984

How can you make the sql query to be based on a specific table of your choice?

1072

What is crass reference table?

1066

1.Have u logical models in project? If s which logical model used? 2.how do u connect to production server? 3. how do u test the data in report is same as in DWH? 4. u created one report but there is no data in the attribute. But how can u extract the data from ware house? 5. u have two tables having different ids how do u merge those table in MSTR? 6. have u faced challenging situation in u r project? Give me one example?

2582

Name some categories in sas 9? : sas-grid-administration

988

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