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 load duplicate records in to a target table which has a primary key?

2 7989

i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

Wipro,

3 7606

In a Single page we are having 3 list. While running each has to populated in separate page?

TCS,

2 6562

A list box contains 1000 records, while running the list, inside the header the content has to scroll down. Note the header should not go up?

1 5038

what is 'reconsideration error' and how can i respond to this error and how to debug this

Wipro,

1 2692

there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities

Wipro,

2 8333

when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

Accenture,

5 16689

what is data modelling? what are types of modelling?In which suituation will use each one?

Accenture,

1 13500

(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance

1 8106

what is optional prompt in boxi r2

Mind Tree,

4 11827

what is BIAR file in business objects xi r2

TCS,

3 19826

date format in report like (22/5/2010 "3:20:15 am") like this i want to remove 3:20:15 remove from report how can we do this in bo xi r2

Honeywell,

1 5654

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

HP,

2 8453

hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

Wipro,

1 5368

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1 2371

Un-Answered Questions { Data Warehouse }

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

1042

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

1200

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

2149

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

1077

What r the names of the reports that you prepared?

1029

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2436

draw informatica architecture 8.6 ?

3945

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 send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3441

hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com

2299

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

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

Explain in detail about scd type 1 through mapping.

1646

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

2127

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

2342

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