DWBI CONCEPTS

Main Menu

• Home
• Certification
• Apply Job 
• Learning Path
• Reporting
  • Home
    • Uncategorised
      • BI Topics
      • Data Warehousing & BI Certification Exam Syllabus
      • Refund Policy
      • Payment Successful
      • Why should you choose DWBIConcepts?
      • Products & Services
      • Contact Us
      • Business Intelligence Certification
      • Trouble to Log-in to the site?
      • Advertise with Us
      • dw-bi
      • DWBI Forum Rule
      • Terms & Condition
      • Privacy Policy
      • Contribute an article to this website
      • A Comprehensive website for DWBI Professionals
    • Reporting & Analysis
      • Business Objects
        • New Features of BO 4.0 WEBI
        • Conditional Column Hiding in BO 3.1 Webi Report Followup Post
        • Conditional Column Hiding in BO 3.1 Webi Report
        • Top 5 BusinessObjects (BO) Scenario Based Questions
        • What is Derived Table in SAP BusinessObjects
        • BO List of values
        • BO Linked Universe
    • DWBI
      • DWBI Basic Concepts
        • Fools Guide to Big data - What is Big Data
        • What is NoSQL
        • What is Data Integration (DI)?
        • What is a data warehouse - A 101 guide to modern data warehousing
        • Data Retention and Purging in a Data Warehouse
        • Business Intelligence
        • What is Data Warehousing?
        • OLTP and OLAP
      • Data Modelling
        • Implementing Rapidly changing dimension
        • Performance Considerations for Dimensional Modeling
        • Dimensional Modeling Approach for Various Slowly Changing Dimensions
        • History Preserving in Dimensional Modeling
        • Dimensional Modeling Schema
        • The 101 Guide to Dimensional Data Modeling
        • Classifying data for successful modeling
        • Common Mistakes in Data Modelling
      • Data Mining
        • Data Mining Insight
        • Data Mining - a simple guide for beginners
      • DWBI Project Management
        • Top 5 Challenges of Data Warehousing
        • Top 10 things you must know before designing a data warehouse
        • A road-map on Testing in Data Warehouse
        • Why people Hate Project Managers – A must read for would-be managers
        • Enterprise Data Warehouse Data Reconciliation Methodology
        • Top 10 things to avoid in DWBI project management
    • ETL
      • ETL Informatica
        • When to use Informatica Stored Procedure Transformation
        • Implementing SCD2 in Informatica Using ORA_HASH at Source
        • Loading Flatfiles delimited by comma and double quotes
        • PowerCenter SOA Components
        • Useful Informatica Metadata Repository Queries
        • Calling C executable from Java Transform
        • What is Active Lookup Transformation
        • Working with Informatica Flatfiles
        • CDC Implementation using Flatfile
        • CDC Implementation using Informatica Variable
        • Stop Hardcoding- Follow Parameterization Technique
        • Informatica Excel Source
        • Informatica Java Transformation
        • APEAR - A tool for automating Informatica Performance Tuning
        • Using Informatica Stored Procedure Transformation
        • How to Tune Performance of Informatica Aggregator Transformation
        • How to Tune Performance of Informatica Joiner Transformation
        • How to Tune Performance of Informatica Lookup Transformation
        • Informatica Performance Tuning - Complete Guide
        • The benefit and disadvantage of Informatica Persistent Cache Lookup
        • How to get Folders and Mapping names from Informatica Metadata Query
        • How to get Informatica Repository Information from Metadata
        • Informatica Metadata Tables - Overview and Tutorial
        • Informatica Join Vs Database Join
        • Comparing Performance of SORT operation (Order By) in Informatica and Oracle
        • Informatica Reject File - How to Identify rejection reason
        • Implementing Informatica Incremental Aggregation
        • Using Informatica Normalizer Transformation
        • Informatica Dynamic Lookup Cache
        • Pushdown Optimization In Informatica
        • Informatica Tuning - Step by Step Approach
        • Implementing Informatica Partitions
        • Aggregation with out Informatica Aggregator
        • Implementing Informatica Persistent Cache
        • All about Informatica Lookup
      • ETL Basic Concepts
      • ETL BODS
        • Fools Guide to BODS - Designer
        • Fools Guide to BODS - Registering Repository to CMC
        • Fools Guide to BODS - Repository Creation
        • Fools Guide to BODS - Introductory Tutorial
        • Real Time Jobs in Data Services
        • DENSE RANK in Data Services
        • GROUP RANK in Data Services
        • RANK in Data Services
        • Data Services Metadata Query Part 3
        • Data Services Metadata Query Part 2
        • Data Services Metadata Query Part 1
        • Data Services Scenario Questions Part 7
        • Data Services Scenario Questions Part 6
        • Data Services Scenario Questions Part 5
        • Data Services Scenario Questions Part 4
        • Data Services Scenario Questions Part 3
        • Data Services Scenario Questions Part 2
        • Data Services Scenario Questions Part 1
        • Exception Handling While Reading Multiple XML Files in Data Services
        • Handling XML source files in SAP Data Services
        • XML file generation using SAP Data Services
        • Web Service Call in SAP Data Services
        • SAP Data Services Analytic Functions
        • How to implement SCD Type 3 in Data Services
        • How to use Data Services Reverse Pivot Transformation
        • How to use Data Services Pivot Transformation
        • Data Services Flatfiles Tips
        • Working with Data Services Flatfiles
        • Data Services Scripting Language
        • How to implement SCD Type 2 using History Preserve Transform in Data Services
        • Table Comparison Transform to Implement Slowly Change Dimension (SCD) in Data Service
        • How to handle multiple input file in SAP Data Services
        • Using MERGE Transform in SAP Data Services
        • SAP Data Services Custom Function
        • How to use SAP Data Services Case Transform
        • How to use Lookup and Join in SAP Data Services
        • Learning SAP Data Services - Online Tutorial
        • Why SAP Data Services
        • Error Handling, Recoverability- SAP Data Services
        • Auditing in SAP Data Services
        • Text Data Processing using SAP Data Services
        • SAP BODS Transforms
        • Getting Started SAP BODS
        • SAP BODS Cluster Installation
        • How to install SAP BODS - Standalone
        • One Stop to SAP BODI/BODS
      • ETL Concepts
        • Why do we need Staging Area during ETL Load
        • Incremental Loading for Fact Tables
        • Incremental Loading for Dimension Table
        • Methods of Incremental Loading in Data Warehouse
        • Building the Next Generation ETL data loading Framework
      • ETL SSIS
        • SSIS- Lookup Transform
        • SSIS- Merge Join Transform
        • SSIS- Aggregate Transform
        • SSIS- Multicast Transform
        • SSIS- Conditional Split Transform
        • SSIS- Union All Transform
        • SSIS- Derived Column Transform
    • Database
      • Database Basic Concepts
        • What is a database? A question for both pro and newbie
      • Database Oracle
        • How to find out Which User is Running what SQL Query in Oracle database?
        • How to find out Expected Time of Completion for an Oracle Query
        • Understanding Oracle QUERY PLAN - Part2 (Exploring SQL Joins)
        • Understanding Oracle QUERY PLAN - A 10 minutes guide
        • Oracle Analytic Functions
        • Oracle AUTOTRACE Explained - A 10 Minute Guide
        • UTL_FILE
        • Different Methods to move data from Oracle to External File
        • Database Performance Tuning
        • Oracle External Tables
        • Learn Oracle Server Architecture in 10 minutes
      • Database SAP HANA
        • SAP HANA Studio
        • SAP HANA Appliance
        • SAP HANA Information Modeler
        • SAP HANA Architecture
        • SAP HANA - An Introduction for the beginners
      • SQL
        • SQL- Data Query Language
        • SQL- Data Manipulation Language
        • SQL- Data Definition Language
        • Introduction to ANSI SQL
    • Tutorial
      • Interview Questions
        • Top 20 SQL Interview Questions with Answers
        • Best BusinessObjects (BO) Interview Questions and Answers
        • Top 30 BusinessObjects interview questions (BO) with Answers
        • Top 50 SAP Business Objects Data Services Interview Questions and Answers -Continued
        • Top 50 SAP Business Objects Data Services (BODS) Interview Questions with Answers
        • Top 25 Unix interview questions with answers (Part I)
        • Best Informatica Interview Questions & Answers - Continued
        • Best Informatica Interview Questions & Answers
        • Top 50 DWBI Interview Questions with Answers - Part 3
        • Top 50 DWBI Interview Questions with Answers - Part 2
        • Top 50 Informatica Interview Questions with Answers
        • Top 50 Data Warehousing Interview Questions with Answers
• Data Warehousing
  • Home
• ETL
  • Home
• Database
  • Home
• Tutorial
  • Home
• Question?