- What is source qualifier?
- Difference between DSS & OLTP?
- Explain grouped cross tab?
- Hierarchy of DWH?
- How many repositories can we create in Informatica?
- What is surrogate key?
- What is difference between Mapplet and reusable transformation?
- What is aggregate awareness?
- Explain reference cursor?
- What are parallel querys and query hints?
- DWH architecture?
- What are cursors?
- Advantages of de normalized data?
- What is operational data source (ODS)?
- What is meta data and system catalog?
- What is factless fact schema?
- What is confirmed dimension?
- What is the capacity of power cube?
- Difference between PowerPlay transformer and power play reports?
- What is IQD file?
- What is Cognos script editor?
- What is difference macros and prompts?
- What is power play plug in?
- Which kind of index is preferred in DWH?
- What is hash partition?
- What is DTM session?
- How can you define a transformation? What are different types of transformations in Informatica?
- What is mapplet?
- What is query panel?
- What is a look up function? What is default transformation for the look up function?
- What is difference between a connected look up and unconnected look up?
- What is staging area?
- What is data merging, data cleansing and sampling?
- What is update strategy and what are the options for update strategy?
- OLAP architecture?
- What is subject area?
- Why do we use DSS database for OLAP tools?
Tuesday, November 11, 2008
DWH Questions
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment