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

What are active transformations? Name them.

1 2626

Can you use flat files in Mapplets.

2660

How many transformations can be used in mapplets.

1944

Can a joiner be used in a mapplet.

1 4122

What are active transformations.

1659

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 2848

Global and Local shortcuts. Advantages.

2041

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 2775

Have you worked with/created Parameter file

1668

What's the layout of parameter file (what does a parameter file contain?)?

Cognizant,

2392

Why do you use Mapping Parameter and mapping variable?

1776

Where do you create/define mapping parameter and mapping variable?

1 3341

Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how

IBM,

1 3705

Slowly changing dimensions, types and where will you use them

1722

What are the modules in Power Center

1688

Un-Answered Questions { Data Warehouse }

Is redshift can be used with AWS RDS?

What are the main services provided by application tier?

989

What is the difference between datawarehousing and businessintelligence?

1109

Explain the hierarchies level data warehousing.

894

How to create Index to the table in the universe designer and how it improves the Query performence

2556

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1110

Can you define slice?

1045

Why AWS redshift is named after Redshift?

what are the categories that sas informats are used to the place the data? : Sas-administrator

1056

what is data governance? : Sas-di

1032

Write different kinds of objects in microstrategy?

1009

Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?

4751

What do you understand by the term 'dynamic cube'?

1021

How to limit decimal places for the variable using proc means?

1086

What are the different types of data warehousing?

963

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