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

2927

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.

2423

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.

2796

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.

4729

Difference between task flow and linear task flow

4459

Un-Answered Questions { Data Warehouse }

What are the data types present in bo?

1074

Can you execute macro within another macro? : sas-macro

955

What could be a data source system?

971

What is a dimension table?

1010

Describe what the SQL Server tempdb and tlog files are used for?

2298

What do the sas log messages “numeric values have been converted to character” mean? What are the implications?

1160

i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm

2351

What is the procedure for creating independent data marts from informatica 7.1?

1029

What are teradata utilities?

1061

What are consolidations?

858

---------------Describe OLAP Reporting and RDBMS Reporting?

2066

Explain security role?

892

What are the transformations that are not supported in mapplet?

982

what is proc Index? and what is proc document?

2661

Explain Dataware house architecture .how data flow from intial to end?

2556

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