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 6240

Can any please explain FOR EACH AND FOR ALL?

HCL, Infosys, TCS,

2 23942

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

Wipro,

1 5294

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

Patni, Wipro,

5 10986

What is meant by grouped star schema

IBM,

2818

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 8390

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 12491

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 6441

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 10913

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

4 15781

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 10199

Roles and Responsibilties of Informatica Production Support Member?

6 57421

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 6795

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

CTS, Wipro,

12565

Un-Answered Questions { Data Warehouse }

What are default access rights in teradata? What explicit right can be given to a user?

1113

What is a look-up?

1270

Define query items?

1023

Enlist the advantages of informatica.

1070

What is the max core of a component?

1103

What is cluster AWS cloud?

Can u access a repository created in previous version of Informatica?

1862

what is the meaning of ending bulk load mode?

4. How many dimensions did you use in your reports?

1955

What are the updated features of teradata?

1046

What are the some differences between 7.x and 8.x version of datastage?

1259

Explain the difference between filter and conditin?

970

what is chore commit property?

explain the difference between proc means and proc summary?

1131

What is meant by alternate drill down with ex?

1092

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