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

Is import wizard, report conversion tool, report comparison tool, security viewer ---- where all r migrating tools. whether all the tools available in BOXIR2? ..

2 7873

how do you test reports in reportnet? what do you record in unit testing documents? pls give answer in detail......

TCS, Tech Mahindra,

2 7036

What are the advantages and disadvantages of using Transformer cube?

TCS,

1 5629

how will optimiz the performance of sql in FM ?

Infosys,

2 8127

how can you restrict the number of values available for a prompt? i tried this by using static choices property, but i dint get result... so pls explain in detail steps....

3 8440

What is the difference between Bitmap and Btree index?

Mind Tree,

3 20240

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 9788

How to delete duplicate record in Informatica?

7 30712

I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?

IBM, KKL, Reliance,

1 2127

Can anyone explain the procedure for configuring cognos8 with oracle as Content Manager/Content Store? I know the configuration of cognos8 with SQL SERVER (Like how to create CM database in oracle and applying securities to access that Database from cognos8 (Cognos Configuration)

AIG, IBM,

7 14248

What is the difference between view and materialised view?

6 14706

what are methods to identify duplicate observations?

HCL,

5 11456

What are the procedures (or) methods using in Migration process in cognos? I.e. the created report is in development server that moves into production server (client server). Shall we drag or copy the file moving from development to production? It is possible or could you tell me that how will we do it?

1 5736

How do you create IQD in FWM? Pls, give the procedure with an example. I told him that we could create using Native SQL method in FWM; it is correct or do you do another method there?

4 8616

How do you schedule process automatically in cognos.I.e we have 50 reports and 100 users that will schedule daily, weekly, and monthly basis? Pls, give the answers the query early on.

3 8376

Un-Answered Questions { Data Warehouse }

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

1769

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

1042

what are the dimensions that you have in your current project?list them?

2093

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2261

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, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2492

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.

1239

how many reports have u created ? explain a few.

2160

faq's on cognos

4112

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2766

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

2060

How do you remove duplicate records in informatica? And how many ways are there to do it?

1231

draw informatica architecture 8.6 ?

3945

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

846

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

1146

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