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 6318

Can any please explain FOR EACH AND FOR ALL?

HCL, Infosys, TCS,

2 24087

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

Wipro,

1 5408

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

Patni, Wipro,

5 11261

What is meant by grouped star schema

IBM,

2912

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 8573

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 12832

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

1 2471

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 6595

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 11161

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

4 15952

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 10485

Roles and Responsibilties of Informatica Production Support Member?

6 57747

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 6921

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

CTS, Wipro,

12630

Un-Answered Questions { Data Warehouse }

How would you format some text using css to be verdana and bold?

1146

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1099

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2175

What is node? How many nodes and amps used in your previous project?

1173

Explain about a time when you discovered a more efficient way to do a work task?

1222

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2167

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3441

How to create the source and target database connections in server manager?

1144

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2093

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

846

Explain about a tricky situation for which you found a very simple solution?

1077

explain in detail about type 3?

1083

What r the names of the reports that you prepared?

1029

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2207

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1996

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