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 are the reusable tasks in informatica ?

CTS, HP, IBM, TCS,

11 55128

HOW DO YOU PARFORM INCREMENTAL LAOD ?

SAIC,

7 17053

WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

Oracle,

4 13886

HOW DO YOU CONNECT TO REMOTE SERVER ?

Patni, TCS,

1 8698

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

Target,

7 34926

how can one connect two fact tables ? is it possible ? how?

ABC, Oracle, Patni,

8 37710

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

IBM,

6 14000

HOW TO PUBLISH A REPORT?

3 8975

HOW TO DEBUGGING A REPORT?

1 9386

WHERE WE USED JAVA CONCEPTS IN ACTUATE?

1 5732

GENARALLY HOW MANY REPORTS ARE CREATE FOR EACH ONE ?PLZ EXPLAIN AFEW FOR AUTOMOBILE PROJECTS?

4 6914

GENARALLY HOW MANY UNIVERSES ARE CREATE FOR EACH PROJECTS?

4 7814

GENARALLY WHAT ARE THE PROBLEMS ARE FACING WHILE CREATING REPORTS?

1 7439

HOW DO YOU SCHEDULE THE REPORTS?

5 9426

HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM?

CitiGroup,

4 10463

Un-Answered Questions { Data Warehouse }

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

1189

can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2324

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4788

what are the names of the reports that you prepared?

1185

Write the unconnected lookup syntax?

1139

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2814

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

2299

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2122

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6056

Explain scd type 3 through mapping.

1065

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

1932

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2415

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2790

How to add default rules in transformer?

1277

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

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