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

. In production reports, some dimensions are missing. how do you load these dimensions in production

2 5702

There is one report running and a user wants to know whether data is from detail table or summary table. what is your approach?

1 3061

. User wants to modify a report and wants to add additional data. How will you approach.

2 5579

12. Report is running very slow and How do you increase its performance? 13. In infoview, I want to provide the hyperlink to view the report in pdf format or other format. is it possible to do it. 14. There is one report and need to add new cloumns which are not there in database. what is your approach.? 15. Did you face any ambiguous queries and how do you fix it?

3 12519

what is Active lock explain

Satyam,

1 2880

What are the different types of code pages available in informatica & how to implement it in your project?

TCS,

1 10783

What is the difference between unicode & ascii mode data movement in informatica?

TCS,

1 12108

What is CDC? How to implement CDC?

People Tech, TCS,

4 23783

Tell me about informatica architecture.

TCS,

2 9779

whenever we using the merging through data set merging ,we can get note in log like this "MERGE STATEMENT HAS MORE THAN ONE ONE DATASET BY REPEATED BY VAIABLES" but the output has come in good manner,whenever in in sql(full join) we can get cartion product.so How do overcome this problem in sql?

Accenture,

1 3952

What is Indexing? how did u implement indexing?

TCS,

1 2618

How to convert HTML file into SAS dataset?

3013

write a query for how to eliminate the duplicate rows without using distinct?

iGate,

6 12469

how to get the first row without using rank t/r?

iGate,

7 13030

what is the command to get the list of files in a directory in unix?

iGate,

5 11408

Un-Answered Questions { Data Warehouse }

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2086

What is dimensional table?

1168

EXL informatica Questions

1463

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2438

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1044

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2306

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1178

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1771

Explain in detail about scd type 1 through mapping.

1648

what is document design in boxi,have u participate in that

2310

Hi, If anyone has base SAS certification dumps, please share.

1943

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2270

What is the difference between business requirement document and use case document.

1086

What is node? How many nodes and amps used in your previous project?

1179

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3668

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