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

get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

Infosys,

2281

get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c

Infosys,

3 9814

if i hv 2 reports in one block... first report contains ten rows and second report contains 100 rows. my question is ....if i want to enter the values into first report(i want more than ten rows in first report)..is it possible to get ..

TCS,

1 4892

Difference between Object varification and validation

Cognizant,

1 3501

1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

Accenture,

2 18118

How to take backup of CMS database and Auditing database, please suggest me with a best possible ways.?

1 6109

what is index?how it can work in informatica

2044

I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK AND DATE VALIDITAION LOAD TO TARGET TABLE

Wipro,

1 5785

what is mapping lookup

1 5274

how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?

DELL,

5 11483

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

IBM,

5 9874

I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

IBM,

2 6735

What is log file,and where is it located,why u r using the log file

TCS,

1 8208

What is the definition of derived table ?

JPMorgan Chase,

2 9642

What is LOGICAL VARIABLES in SAS.And how it can be used..Can anyone support..???

3 12312

Un-Answered Questions { Data Warehouse }

Explain what is the difference between a primary and secondary actor in use case modeling?

1075

Can you explain the co>operating system’s processing model?

1107

How do you load first and last records into target table?

1160

What is meant by incremental load?

1100

AGGREGATOR default datatype

1463

What are dimensions?

1071

Describe implicit attribute?

1020

What is the difference between informatica and datastage?

1235

What is mapping debugger?

1022

How would you join a node to the already existing domain?

1131

what are sas bi dashboard components? : Sas-bi

1174

Difference between project merge and object manager in microstrategy?

999

What is substr function?

1197

How does a sorter cache works?

1075

How do you take back up of repository?

1162

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