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 7548

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

IBM,

2 10248

How can you view the data in the Multifile

IBM,

4 23061

What is the best way of creating huge test feeds?

1 6546

How will you check the latest versions in EME?

6 18450

What is the DynamicScriptGeneration and what is the Use?

2 9533

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

5 27232

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 14280

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 8716

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 6965

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 24444

how to implement scd2 in datastage 7.5 with lookup stage

TCS,

5610

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 10303

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 3502

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 4792

Un-Answered Questions { Data Warehouse }

What is the different lookup cache(s)?

1093

in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt

1914

Compare cold fusion with other programming languages?

1012

How to test a cube?

2202

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2364

explain the concepts and capabilities of business object? : Sas-bi

969

Can you explain engine tier in information server?

1138

what are validation tools that are used in sas? : Sas-administrator

1063

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2283

Explain standard filters?

1014

What are the issues you have faced in your project? How did you overcome those issues?

2366

To save time, can many reports be run at the same time?

1035

What is the SAS data set?

1140

What is the difference between ‘macro’ and ‘prompt?

1090

Explain a linked cube?

961

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