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 have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1242

Explain in detail scd type 2 through mapping.

1005

How do you load unique records into one target table and duplicate records into a different target table?

1180

Explain the different kinds of facts.

950

How do you load only null records into target?

1164

What is fact table? Explain the different kinds of facts.

1036

How many ways are there to do 'remove duplicate records in informatica'?

973

How to join three sources using joiner? Explain though mapping flow.

1112

How do you load only null records into target? Explain through mapping flow.

1980

I have a dataset concat having variable a b & c. How to rename a b to e & f?

989

How do you specify the number of iterations and specific condition within a single do loop?

1067

Briefly explain input and put function?

1055

Give some examples where proc report’s defaults are same as proc print’s defaults?

1079

What is the length assigned to the target variable by the scan function?

1127

What is the difference between one to one merge and match merge? Give an example.

1017

Un-Answered Questions { Data Warehouse }

Name some categories in sas 9? : sas-grid-administration

934

Is redshift can be used with AWS RDS?

How would you define the end of a macro?

1061

What is meant by incremental load?

1043

What is the difference between olap and oltp?

993

1.Have u logical models in project? If s which logical model used? 2.how do u connect to production server? 3. how do u test the data in report is same as in DWH? 4. u created one report but there is no data in the attribute. But how can u extract the data from ware house? 5. u have two tables having different ids how do u merge those table in MSTR? 6. have u faced challenging situation in u r project? Give me one example?

2527

Explain data_null_?

1015

Explain by-group processing?

963

What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

1036

how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

2505

What are stage variables, derivations and constants?

1188

What is ibm datastage flow designer?

1104

How to extract sap data using informatica?

1012

What are the types of hierarchies?

991

At which levels you can set the vldb properties? Which level has the highest pecedence?

917

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