Digvijay

• Jul 13th, 2014

 

Use a Router transformation and create 3 groups with condition as

Group_A : UPPER(SUBSTR(First_Name,1,1))=A
Group_S : UPPER(SUBSTR(First_Name,1,1))=S
Group_J : UPPER(SUBSTR(First_Name,1,1))=J
Others

By using above all rows having first name starting from A gets loaded through Group_A, First names with letter S gets loaded through Group_S. If the First name starts with letters other than A, S and J, then it gets loaded through others.

Abhinav

• Jul 14th, 2014

 

You Can use INSTR function inside expression T/R and find the respective characters and raise a subsequent flag for Each Characters.Use Router T/R to send these records to multiple targets.

amrie

• Jul 30th, 2014

 

In the expression
Create a variable port
v_employee=

IIF(
substr(EMPLOYEENAME,1,1)=A,FLAG1
IIF(
SUBSTR(EMPLOYEENAME,1,1)=S,FLAG2,
IIF(
SUBSTR(EMPLOYEENAME,1,1)=J,FLAG3,FLAG4 )))


create a output port in the same expression
o_employee=v_employee

IN THE ROUTER MAKE 4 GROUPS
GROUP1
o_empoyee=FLAG1

GROUP2
o_empoyee=FLAG2

GROUP3
o_empoyee=FLAG3

GROUP4
o_empoyee=FLAG4

these 4 groups are connected to the 4 targets
note : Flag4 CONTAINS VALUES OTHER THAN A,S,J

Sandy

• Aug 31st, 2014

 

To make current answers generic and mapping applies even if you get more names starting with different characters:

Use Sorter, Expression & Transaction control transformations
- Using sorter transformation, sort the data either in ascending or descending order on the Employee name field
- In the expression transformation:
use substring function to get the first character of employee name and hold it in a variable port.

compare the first character of current employee name with the previous employee name, if change is noticed then go with commit after, otherwise continue transaction.

Use the property to dynamically create the target table and assign the name of the table with the help of expression transformation.