Data Warehouse Interview Questions
Questions Answers Views Company eMail

Explain about cumulative Sum or moving sum?

Informatica,

758

Explain lookup transformation source types in informatica

Informatica,

842

What is a transaction control transformation?

Informatica,

918

Define mapping and session?

Informatica,

735

Design a mapping to load the cumulative sum of salaries of employees into target table?

Informatica,

1110

How to create or import flat file definition in to the warehouse designer?

Informatica,

806

What are ETL Tools?

Informatica,

810

What are the types of data warehouses?

Informatica,

1108

How to partition the Session?

Informatica,

790

How to create Target definition for flat files?

Informatica,

922

How do you handle two sessions in Informatica

Informatica,

827

What are the guidelines to be followed while using union transformation?

Informatica,

818

Which transformation should we use to normalise the COBOL and relational sources?

Informatica,

905

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

Informatica,

788

What is aggregate cache in aggregator transformation?

Informatica,

781


Un-Answered Questions { Data Warehouse }

(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1182


permutations of mapplet

2214


How to open a universe with out using the Designer ??

6925


how can you direct the sql generated to use a specifc table?

664


------------ Diff b/w MemberCaption and MemberDescription?

2042






Explain informatica architecture?

694


How are models actually derived?

1689


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

1899


How would you get two images on microstrategy login page?

676


Describe primary index in teradata?

729


Explain functional dependency?

751


What do you mean by inmon?

786


How we can monitor the performance of Redshift data warehouse cluster.

5


How do we drill through from a powerplay cube to reportnet?\

2044


What is main use of mapplet?

813