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

How to do unit testing in informatica?

1 1245

How to handle decimal places while importing a flatfile into informatica?

1 1255

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1 1085

What is the procedure for creating independent data marts from informatica 7.1?

1 1140

can we override a native sql query within informatica? How do we do it?

1 1206

How to load the data from people soft hrm to people soft erm using informatica?

1 1087

What is the difference between informatica 7.0 and 8.0?

1 1083

Whats the difference between informatica powercenter server, repositoryserver and repository?

1 1232

can we override a native sql query within informatica? Where do we do it? How do we do it?

1 1131

where to store informatica rejected data? How to extract the informatica rejected data?

1 1074

Explain how many types of dimensions are available in informatica?

1 1198

How to create an external dataset with sas code?

1 1278

how can we direct the sql generated to use a specifc table?

1 994

what are logical views used for?

1 1064

How to optimize a report in microstrategy environment?

1 1032

Un-Answered Questions { Data Warehouse }

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

2150

Explain about a tricky situation for which you found a very simple solution?

1077

Hi friends, what are the new features in abinito3.0?

2860

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

2306

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8286

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

6077

Explain how to generate iqd file from framework manager?

1022

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)

2794

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1670

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2342

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

1083

how to generate the test data in sas without input data? : Sas-administrator

1202

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

2094

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

1997

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

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