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

What is the Main Difference between Conditional Block and Render Variable in Cognos. Both are used for Condtional rendering.But what is the Main Diff?

Wipro,

4 39193

how can we join two classes with full outer join.in join dialog box only one outer join check box is checked another on e gone .for this any property is there in universe designer?

TCS,

2 8691

If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

TCS,

3 7432

Which will beter perform IIf or decode?

TCS,

3 18774

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1 1987

comonly how meny mappings r there in Banking projects?

1 5598

how can you get the single data set from the library(which has the number of data sets)?

Accenture, Deloitte,

3 10217

What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?

1 9984

How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition

TCS,

6 26717

Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj

2 6800

Can anybody tell me . Is it required CMS Server for Desktop Intelligence Reports?

3 7502

What is the Difference b/w Server based Ranking and normal Ranking?

1 7047

hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd

IBM,

9 11150

While running the reports how can we hide totals if the users doesnot requie it?

Satyam,

3 6950

While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?

4 9254

Un-Answered Questions { Data Warehouse }

Hi, If anyone has base SAS certification dumps, please share.

1940

What is aggregate table and aggregate fact table ... Any examples of both?

1119

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

2169

What are the data types present in bo? What happens if we implement view in the designer and report?

1082

What is rollup component?

1337

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2127

What r the names of the reports that you prepared?

1032

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1200

What sort of existing documents should business analysts refer to when starting on a new project?

1078

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6077

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

1144

What is dimensional table? Explain the different dimensions.

1270

Are you involved in writing the inferential analysis plan? Tables specifications?

4019

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2267

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2066

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