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

) Layout? What is the Dataset & Program Component Layout

TCL,

2 7541

What is the Reformat Layout?(i/p ->Reformat->o/p)

IBM,

2 10244

How can you view the data in the Multifile

IBM,

4 23043

What is the best way of creating huge test feeds?

1 6542

How will you check the latest versions in EME?

6 18440

What is the DynamicScriptGeneration and what is the Use?

2 9528

) How can you count the total no .of records in the specified partition in the Multifile?

5 27220

id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???

Cap Gemini,

6 14269

i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com

Wipro,

2 8711

i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?

Wipro,

2 6958

Cognos TM1 1. What are the different windows in Turbo Integrator? 2. What is the use of advanced window in Turbo Integrator? 3. What is TM1 Workflow. How do you create a process in that? 4. Where is Portlet used. What are differnt windows in portlet. How can you access TM1 web from portlet? Cognos 8. 1. What is Drill-on? 2.How do you implement row level security in Framework Manager? 3. How do you create tree prompt?

HSBC,

1 24440

how to implement scd2 in datastage 7.5 with lookup stage

TCS,

5606

whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?

HCL,

5 10289

I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?

Franklin Templeton,

1 3492

My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify

TCS,

1 4786

Un-Answered Questions { Data Warehouse }

What are constraints and derivations?

1170

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2204

What do you mean by mstr?

1098

What are the differences between oltp and olap?

972

How can we handle two sessions in informatica?

1033

lookup transformation with screenshots

4006

what are the considerations when picking a SAS/STAT procedure?

3375

What are the steps to create a data model?

1054

What is the use of powerplay web viewer in cognos?

1089

What is a bo repository?

1045

tell me the rules and responsblites in our project(my project is development)

1933

What r the names of the reports that you prepared?

981

r u done any partitions in ur project?

1827

What is is the guidelines to build universe with better performance? R performance tuning issues of universes?

898

What is the basic structure of the SAS base program?

1330

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