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

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1 2168

What is the difference b/w natural key and surrogate key

1 5578

My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?

Cap Gemini,

3 10007

what are the types of Data warehousing ?

1 3142

what are the types of facts with Examples?

3 6126

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

HP,

3 9424

Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR

Cap Gemini,

4 12796

HI i have a table with 4 columns in back end like sales id, sales revenue, order id and order amt. Now i have created 2 prompts at query level 1st on sales id and 2nd on order id. Now if i run the report for 1st prompt it has to display sales id and sales revenue. Then if i run the report for 2nd prompt then it has to overwrite the table with Order ID and order amount. How you will handle this?

1 4278

What are the tuning techniques you applied during your last project

1 2092

i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

3 7917

my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica

HP,

3 7997

How we will implement Pushdown Optimization and Types in Informatica with better examples

TCS,

4 14218

How to remove ctrl M or(^M) characters in file using Sequential File stage?

Bank Of America, Satyam,

2 22380

any difficulitis have you phase while creating bo reports and how did u solve it

1 3515

what is projection function in SAP BO

Cap Gemini,

1 11964

Un-Answered Questions { Data Warehouse }

Explain in detail about scd type 1 through mapping.

1641

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

1932

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3648

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

1839

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 Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2250

What are the data types present in bo? What happens if we implement view in the designer and report?

1076

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2201

Have you have ever worked in unix environment and why it is useful in datastage?

1210

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

2853

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

1073

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2087

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1193

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 ?

2081

How would you format some text using css to be verdana and bold?

1133

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