Home | Contact Us | Sitemap
DWHlabs provides Data Warehouse education services.This web portal is very useful to the Database professionals,
Data Warehouse professionals, UNIX professionals etc.,
  About Us Advertise Support us Tell your Fren Testimonial Contact Us  
 
 
Please help us continue development of this website and it's services!
 
 

 


 
DWHlabs- ETL TOOL
Sponsered Links
 
 
MAPPINGS PAGE - TRANSFORMATION MAPPINGS - ROUTER TRANSFORMATION
 
 
Transformation : Router (rtr_)
Explanation :
Router transformation is a active transformation.
Routes data into multiple transformations based on group conditions.
A Router transformation tests data for one or more conditions and gives you the option to route rows of data that do not meet any of the conditions to a default output group.
 
GROUPS ::
 
User Defined Groups
 
  • You create a user-defined group to test a condition based on incoming data. A user-defined group consists of output ports and a group filter condition.
  • You can create and edit the user-defined group.
 
Default Group
 
  • The Designer creates the default group after you create one new user-defined group. The Designer does not allow you to edit or delete the default group.
  • If you want the PowerCenter Server to drop all rows in the default group, do not connect it to a transformation or a target in a mapping
 
REMEMBER ::
 
Zero (0) is the equivalent of FALSE, and any non-zero value is the equivalent of TRUE
 
Download :
XML FILE    
m_rtr_sal_dept    
     
DWH 3Colors
CERTIFICATION GUIDE
DATA DICTIONARY
ALL ARTICLES
   
DWH CONCEPTS

DWH Architecture
Types of Schema
Normalization

VS LINKS

OLAP Vs OLTP
Dimension Table Vs Fact Table
Datamart Vs Data Warehouse
Data Mining Vs Web Mining


SHARE KNOWLEDGE

Now viewers can share their information with DWHlabs , please
Click Here.
Please send your feedback
Click Here .
Tell you friend about DWHlabs
Click Here .


Data Warehouse Lab

- ETL TOOL
INFORMATICA
OTHER TOOLS

- REPORTING TOOL

BUSINESS OBJECTS
OTHER TOOLS

Database Lab

- ORACLE
SQL
PL/SQL

- DB2
OTHER TOOLS

Unix Lab

Project Lab

DWH Schools

Books Store



 
  About Us Advertise Support us Tell your Fren Testimonial Contact Us  
© 2008 DWHlabs
Privacy Policy | Terms & Conditions