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

I am in chennai.I need Micro strategy ,Informatca & BO cd (not orginal)Please where get that.I really this badly. Regards, Raji

1 4249

How can you schedule a report based on different time zone ?(ex: local time should be same as 10 am . Japan should get the report at 10 am. USA should get the report at 10 am).Is that possible?

HCL, iGate,

1 9055

Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma

1 3567

hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com

1 2250

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

Cap Gemini, CTS,

6 15649

Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S

3 10169

how to change left and right links in join stage?

Cap Gemini, IBM,

4 10599

Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance

Cap Gemini,

6 14462

suppose one Cylinder split data blocks are moved from where?

1 4321

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

IBM,

1 2923

Explain Process flow in data warehouse??

BirlaSoft,

1 5502

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

Cap Gemini, Cognizant,

1 2786

Steps to create alias and apply

2 5638

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

Bosch,

1 2183

What is the difference between Bulk Load and Normal Load

TCS,

3 13367

Un-Answered Questions { Data Warehouse }

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

1189

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2253

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

2853

Are you involved in writing the inferential analysis plan? Tables specifications?

4011

Demonstrate experience in maintaining quality process standards?

2658

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

2138

How to add default rules in transformer?

1277

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

3648

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

1932

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

1194

What is dimensional table?

1145

faq's on cognos

4108

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2250

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

1193

explain in detail about type 3?

1078

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