DWBIConcepts.com

DWBI CONCEPTS

Community of DW & BI professionals
Register or SignIn Register Or Sign-In
  • Home
  • Certification
  • Apply Job
  • Learning Path
  • Reporting
  • Data Warehousing
  • ETL
  • Database
  • Tutorial
  • Question?

Join the Community

Newest Articles

  • Top 20 SQL Interview Questions with Answers
  • 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

Main Menu

  • Home
  • Certification
  • Apply Job Link opens new window
  • 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?
 

About
Contact Us
About Us
sitemap

Legal
Terms of Use
Privacy Policy
Why DWBIC?

Resource
Products & Services
Contribute an article
Advertise with Us

Facebook Twitter LinkedInYoutube

© 2013 DWBIConcepts. All rights reserved.
Names and logos are registered trademarks of companies

Login Or Sign Up (Trouble to login?)

Facebook User?
Log-in or sign-up using your facebook account for quick and easy access
Or, you can also use your LinkedIn account to log in
Login With LinkedIn
Use your DWBIConcepts account


Forgot Login?