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

Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer

2963

Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.

2474

Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.

2829

Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.

4767

Difference between task flow and linear task flow

4505

Un-Answered Questions { Data Warehouse }

What are the features of datastage flow designer?

1039

What is an object prompt in microstrategy?

1008

Can microstrategy desktop access sap data?

948

Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?

2250

What are the ways in which macro variables can be created in sas programming?

1103

What is the architecture of abinitio?

1099

Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

1114

Differentiate between data file and descriptor file?

1059

What Amazon redshift built for ?

Explain direct and indirect flat file loading (source file type) - informatica

1318

When do we go for the tools in the market?

947

Syntax for case when statement?

1063

What is tracing level?

1068

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

779

What we need to discuss with designer before starting the universe designing.

2251

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