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

architecture of cognos8

IBM, Sonata,

1 6237

Can any please explain FOR EACH AND FOR ALL?

HCL, Infosys, TCS,

2 23936

how can one come to know wether the records loak into the target if we use update strategy

Wipro,

1 5288

how can one eliminate dupliacte data with out using distinct option?

Patni, Wipro,

5 10983

What is meant by grouped star schema

IBM,

2816

We have a string like this "kannafromsalembut" ,from this i want to get only "fromsal" (but one condition with out using substring function)here we can not use scan because in the given string there is no delimeter? so give ans without out using substring ?

5 8386

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

TCS,

7 12483

What are the difficulties u faced while doing vital signs table or dataset?

2397

What happens in the following code, if u type 8 instead of *? proc sql noprint; create table abc as select 8 from lib.abc; quit;

3 6435

SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?

IBM,

6 10901

What is the difference between correlated sub queries and inner queries?

4 15777

i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage

6 10195

Roles and Responsibilties of Informatica Production Support Member?

6 57413

i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00

2 6792

What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?

CTS, Wipro,

12559

Un-Answered Questions { Data Warehouse }

Explain in detail about type 1?

1671

what are the steps to troubleshoot the feeders?

How to implement security measures using repository manager?

1182

Which function is used to count the number of intervals between two sas dates?

1132

Explain fact degradation?

996

how to export or import the jobs in .ISX file

1203

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1135

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

1024

what are all the reports you generated in your recent project?

2199

Explain the importance of surrogate key in data warehousing?

1192

How to add a number to a macro variable?

994

How to add default rules in transformer?

1225

How to calculate fact table granularity?

1022

Difference between SAS STATA & SPSS?

1125

What is defined as Query studio?

1106

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