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 is the size of u r project? and what is the size of source file?

HP,

1 6008

what is the size of u r source(like file or table)?

HP,

1 2312

my source is junk data how will u remove that junk data by using unix please any one replay me

Cap Gemini,

1 3757

how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me

Cap Gemini, IBM,

16 26036

explan ur project architecture?

TCS,

1 2136

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?

TCS,

3 10227

i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 12906

How can you change from reusable session into non-reusable session.

Cap Gemini,

5 42909

every alternative row should be hilighted ? how u can ?

1 5664

why we are using derived tables ?how it will help?

2 6244

how u restrict the values?to display 5 values insted of 10 values?

4 8204

what is mean by lov?

4 10524

limitaions of cross tab ?

1 6044

write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

TCS,

8 10282

I want load the data into target with out 1st and last record.

Yash Technologies,

5 10228

Un-Answered Questions { Data Warehouse }

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

2429

Explain scd type 3 through mapping.

1068

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1960

draw informatica architecture 8.6 ?

3939

Write the unconnected lookup syntax?

1142

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

2816

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

2298

faq's on cognos

4112

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

1843

What is the purpose of Dataware Control?

1113

What is aggregate table and aggregate fact table ... Any examples of both?

1117

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

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

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

1769

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

4790

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