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

HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

CTS,

8 15379

What is #DATASYNC error how to remove it?

IBM, TCS,

2 62009

I need help in merging two different datasets. I am merging by date and I want to propagate observations from one dataset to the corresponding dates. One dataset has a unique date for each day of the month, while the other dataset has same date for different patient visits. For example I want to spread an observation on the 31DEC2008 from one dataset to several observations with the same date on a second dataset for all the patients who visited on that date. I have tried to merge the two and the result is not what I wanted. Instead I get a dataset whereby all the dates have missing values where observations from the first datset should have spread.

1 5138

Can anybody explain what mean by Database Delegated Measures?

TCS,

2 21687

which domain is better in sas? clinical trails or banking

3 19413

what is the difference between proc means and proc tabulate?

Cognizant, CTS,

3 17293

what are the errors,warnings in datastage

Syntel, Wipro,

1 2799

What is Fastly Changing Dimension?

TCS,

6 14285

What is RCP?

TCS,

2 11081

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

Cap Gemini,

11 32441

What is the main difference between peek stage and copy stage

2 18959

I installed AbInito in my PC.In components there is no "select" component.How can i get that component?and How we can create user defined components?

1 2131

There are some reports,we have to provide security to that reports like the hr manager should have access to hr department reports only and the accountant should have access to accounts reports where as the CEO can have access to all the reports. How to deal with this situation using Cognos?

BitWise,

2 9522

what are fact tables and dimension tables? give example assuming one table.

IBM,

3 8819

WHAT IS FORCE COMPILE?

FIS, HCL, Polaris,

3 24462

Un-Answered Questions { Data Warehouse }

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

4796

Demonstrate experience in maintaining quality process standards?

2676

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)

2796

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

1998

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

1771

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 all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2438

how many reports have u created ? explain a few.

2162

draw informatica architecture 8.6 ?

3949

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

2153

EXL informatica Questions

1463

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

2306

How to create the source and target database connections in server manager?

1144

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..

2772

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1853

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