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 7650

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

IBM,

2 10376

How can you view the data in the Multifile

IBM,

4 23248

What is the best way of creating huge test feeds?

1 6616

How will you check the latest versions in EME?

6 18628

What is the DynamicScriptGeneration and what is the Use?

2 9609

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

5 27441

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 14512

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 8830

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 7075

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 24512

how to implement scd2 in datastage 7.5 with lookup stage

TCS,

5671

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 10466

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 3570

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 4864

Un-Answered Questions { Data Warehouse }

Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

1318

What are situations where snow flake schema is better than star schema to use and when the opposite is true?

1046

What are the implications?

1790

What is set to be Cognos configuration?

1084

What is the very basic difference between data warehouse and operational databases?

1034

Give the benefits of data integration suite?

963

If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

2260

How does hashing happens in teradata?

1150

Is AWS Redshift a stored procedures?

What information does a .dbc file extension provides to connect to the database?

1295

What specific features and functionality do I get with olap services?

1017

What is meant by query override?

1118

Under which circumstances, informatica server creates reject files?

1142

What is stored procedure in teradata?

1093

Define Pmrep command?

1118

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