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 38916

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 8565

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 7259

Which will beter perform IIf or decode?

TCS,

3 18602

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

1904

comonly how meny mappings r there in Banking projects?

1 5470

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

Accenture, Deloitte,

3 9974

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 9894

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

TCS,

6 26412

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 6657

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

3 7304

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

1 6927

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 10781

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

Satyam,

3 6767

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

4 9063

Un-Answered Questions { Data Warehouse }

How many transformations can be used in mapplets.

1935

flat filevalidation in informatica

2154

hi my name is siraj i want to know cognos queriy language

2272

What is the purpose of pivot stage?

1168

Is it possible to join multiple Databases in a Catalog?

1121

What are the tracing options available in microstrategy object manager?

982

What is the difference between server job and parallel jobs?

1155

Briefly explain the aggregator transformation?

1010

What are the uses of bynets in multi-node systems?

1031

Can I access intelligent cubes without olap services?

1048

Can we create a node as a gateway node and the same node can be assigned to a grid?

1079

What is ibm datastage flow designer?

1149

explain about dirty dimension?

1176

How to select first n records in teradata?

1107

what is function of retain statment

2041

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