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

I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.

TCS,

2 9789

where we use column generator stage in real time scenario?

TCS,

5 26936

What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh

ACS,

6 13996

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...

2056

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com

2073

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

Accenture, HCL,

6 17763

i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

2004

describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

2317

my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

2006

wt is the differnce between Block & conditional block ?

2 17638

wt is scope relationship?

2 7437

How can we create regular dimensions & measure dimensions?

2 5881

Wt is the Diff between Business Key & member caption?

2 31478

It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

2444

How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

3308

Un-Answered Questions { Data Warehouse }

Your application mode has crashed. How would you run your i-server?

986

What is decode in informatica?

1170

How do you promote a non-reusable transformation to reusable transformation?

1138

Enlist few areas or real-time situations where informatica is required.

1092

What are the other methods working as deployment functionality?

951

What is the different between functions and PROCs that calculate the same simple descriptive statistics?

1800

If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

1024

What is the conflict resolution window?

1055

What is the difference between stop and abort in informatica

1099

What are fundamental stages of data warehousing?

1046

Explain sql transformation in script mode examples in informatica

1141

What is meant by a Parsing Engine?

1191

What do you understand by ‘ibm predictive maintenance and quality’?

993

how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

1348

What is cognos connection?

1303

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