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

How to find out no. of business days in a month using macros.???(excluding weekends and holidays).

HSBC,

2 10699

what is the difference between x=substr(name,1,2); and substr(name,1,2)='x';

HSBC,

3 11952

Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?

Cognizant, HCL, TIAA CREF,

8 28720

Hi All, When user run the cognos report, that report output data must be download/available in EXCEL / CSV file.? (like... list report contain PL,PT,PN,RVEN, that excel/csv default download must be list columns PL,PT,PN,REVN) Thanks in Advance, LN.

IBM,

2 6497

how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)

Cognizant, HP, TCS,

3 12491

IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

Accenture, Rolta, TCS,

2 10422

I have a value prompt in my prompt page.Now if I set the filter to required then I have to select a value from the list and I will get the respective data in the report page.But If I select nothing then I will get the complete data in the report page. I want that if I select nothing from the prompt list then nothing is displayed in my report page. How should I do this?

Cap Gemini, HSBC,

1 6719

What is Cardinality b/w Fact to Fact?

IBM,

4 10297

What is portal page?

TCS,

5 8717

What is highest missing value for numeric?

1 8056

Any one suggest me best SAP Business Objects XI Online Training institute from India

Aetna,

2 5581

What is the difference between SI and JI?

2 7570

I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.

Cap Gemini,

4 14020

I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.

4 10308

Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??

IBM,

1 8575

Un-Answered Questions { Data Warehouse }

Why sorter is an active transformation?

1208

What is data mapping and data modelling?

1565

Is it possible to create multiple domains on a single Informatica server?

1255

Where do you see different stages in the designer?

1109

How do you truncate a table?

1184

What is informatica? Why do we need it?

1119

How many dimensions are there in informatica?

1103

How to export mappings to the production environment?

922

What is the different type of jobs in datastage?

991

what are the tables used in health care domain project and columns used in report?

4519

Which lifecycle we will use for reporting?

988

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1071

What are the key columns in Fact and dimension tables?

991

Explain what would you consider as your biggest achievement and why?

994

What is meant by Reportstudio shortcut?

2198

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