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

Aborted in Phase 2 data acquistion completed in fastload?

2 5816

Fast Load Script is failed and error tables are available then how do you restart?

TCS,

3 15280

How do you Generate Sequence in Teradata?

TCS,

3 16174

How do you Generate sequence at the time of Display?

Infosys,

2 8450

There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?

IBM,

4 9222

Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?

4 12895

Why Multiload does not supports USI and supports NUSI?

4 21674

what is the custome stage in datastage? how can we impliment that one? plz tell me

Accenture,

2369

How do we implement materialized view?when to use materialized view?

TCS,

1 7806

In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?

Polaris,

2 18590

my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...

1 4225

source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........

Patni,

3 9642

In which situations we can use normal and sparse lookup stages

IBM,

4 15942

where to select code page option?

TCS,

2 7168

How to run the Teradata jobs in unix environment ???

IBM,

4 16858

Un-Answered Questions { Data Warehouse }

What is the status code in stored procedure transformation?

1185

What is program data vector (pdv)?

1301

What is the difference between filter and lookup transformation?

1113

What are the different methods of loading dimension tables?

995

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2259

Explain substr function?

1120

How to extract sap data using informatica? What is abap? What are idocs?

1185

What is a pdv and what are its functions?

1157

What is data mart in data warehouse?

957

which features do you use to check the data validations and errors? : Sas-administrator

1061

List out the file extensions used in abinitio?

1095

What are the benefits of data processing according to you?

1217

explain the methodology of Data Warehousing?(Polaries)

2021

Can we create universe with no cache??

2515

what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

2240

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