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 38950

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 8581

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 7287

Which will beter perform IIf or decode?

TCS,

3 18630

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

1920

comonly how meny mappings r there in Banking projects?

1 5479

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

Accenture, Deloitte,

3 10008

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 9904

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

TCS,

6 26447

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 6677

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

3 7326

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

1 6937

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 10827

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

Satyam,

3 6792

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

4 9089

Un-Answered Questions { Data Warehouse }

Ist the schema that a data warehouse system can implements.

955

Explain the difference between union and group?

1121

I need a good brd and uc template?

1100

Can anyone explain me a scenario from banking and finance...more precisely a mapping

2511

Notification Activity

1424

Explain what are the advantages and disadvantages of reporting directly against the database?

1017

What is the basic syntax of a sas program?

1226

What is informatica architecture?

1077

What are the difference between snow flake and star schema?

1016

Can reports be executed in off-peak periods?

1013

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

971

If a variable contains letters or special characters, can it be numeric data type?

1223

Why redshift Distribution key is used?

Explain differences between star and snowflake schemas?

1169

Explain fact relation?

1029

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