Can someone plz suggest me how do i utilize a switch stage......
I am not getting any clue regarding what i need to declare in the case field
when i am using usetr defined mapping.............
How to use the switch stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 132
- Joined: Tue Sep 04, 2007 11:38 am
- Location: NOIDA
-
- Participant
- Posts: 334
- Joined: Fri Dec 01, 2006 5:17 am
- Location: Texas
Hi ,
Case statement in switch is used to pass the value of the column.
In our project we are using switch stage to get output from column name mentioned in the source.
In the property tab there are following option:
Input:
Selector="Select the column_name"
eg:my column_name is TABLE_NAME
User-defined mapping:
Case="Value of teh input column_name to be passed "
eg:my coulmn TABLE_NAME has values like CUST_DETAILS,AGENT_DETAILS ans so on...
Option:
If Not Found=Depending upon your requirement.
Now in the case statement if select CUST_DETAILS, my column TABLE_NAME will have only CUST_DETAILS, no other values.
Case statement in switch is used to pass the value of the column.
In our project we are using switch stage to get output from column name mentioned in the source.
In the property tab there are following option:
Input:
Selector="Select the column_name"
eg:my column_name is TABLE_NAME
User-defined mapping:
Case="Value of teh input column_name to be passed "
eg:my coulmn TABLE_NAME has values like CUST_DETAILS,AGENT_DETAILS ans so on...
Option:
If Not Found=Depending upon your requirement.
Now in the case statement if select CUST_DETAILS, my column TABLE_NAME will have only CUST_DETAILS, no other values.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: