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

We had a number of reports scheduled to run at various times. This worked fine for at least a year, now it is the second time round we lost all the scheduled jobs, with no apparent reason we can find. Any ideas?

1 955

What is the difference between 'using group by in the sql of the report' and 'having a group section in the report'?

1 998

Where we use afc in actuate?

1 1101

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1098

What is data stream and data adapter is it same are different?

1 1035

How to generate a report by getting values from two reports. The generated report should contain the 5 values of first report and last 5 values of second report?

1 1044

What is afc?

1 1073

What is data stream and data adapter is it same are different? Explain?

1 1043

What is static and local variable?

1 1093

What is the main difference between schema in rdbms and schemas in datawarehouse?

1 1174

What is surrogate key? Where we use it explain with example?

1 982

Explain can a dimension table contains numeric values?

1 1026

What is crass reference table?

1 1109

What is a fact, dimension, measure?

1 1316

Explain difference between e-r modeling and dimentional modeling?

1 1044

Un-Answered Questions { Data Warehouse }

How to add default rules in transformer?

1282

What is aggregate table and aggregate fact table ... Any examples of both?

1118

Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2145

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 ?

2084

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1960

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1206

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1233

What is rollup component?

1328

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

1035

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2056

How would you format some text using css to be verdana and bold?

1135

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1993

Write the unconnected lookup syntax?

1142

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1193

what are the names of the reports that you prepared?

1189

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