Sravan Kumar
Answered On : Jan 2nd, 2007
Its so simple to Use Router Transformation.Find the procedure
1.In Mapping Designer Work space drag ur source Table and 10 Target Tables(each target to capture individual languages,10 Targets to capture 10 Languages).
2.Go to the transformation tab and select create
3.Choose Transformation type as Router.Enter the name of the Transformation.
4.In Router transfermation we have Two Groups.1.Input group.2.Out put Group.
5.Out put Group is further classified into 2 Groups they are Userdefined group and default group.
6.Match the ports from source to router transfermation.
7.Double click the router transfermation and select the conditions tab.
8.And click on add a new condition
9.Create 10 conditions as u have to load 10 different languages to the target.U can also give 9 conditions becouse 1 condition is defualt.All the condition which satisfies the conditions goes to the targets .The ommited rows are captured by default conditions.
10.Now the Router transfermation is Created with one input group and 9 output group and 1 default group.
11.Match the output group ports to the idividual targets.Depend on the condition.
Ex: Give the Conditions as follows.If u have a Source column with the Name languag.Then give the first condition as Language=english.,Second condition as language=French Like so.
12.Match the ports from router transfermation to Target tables based on language u selected.i.e we have 10target tables and 10 out put groups in router transfermations.
Rest is same i.e create session and then work flow save run the work flow.
Bye ........
Login to rate this answer.
s
Answered On : Jan 2nd, 2007
U hv to giv different filter conditions in different user defined groups
eg:conutryname='India'
countryname='USA'
Login to rate this answer.
hey..In continuation with the above, i have a question here..
1. I have to merge all these data to one single table , how should i do it ?
2. I am getting same data for all the 10 countries so i would like to optimze this instead of a router !!! like a reusable transformation, where to set it up either in the session or in the transformation itself.
Thanks in advance.
Infoseeker
Login to rate this answer.
you mean you can't fufill it??
Login to rate this answer.
Guest
Answered On : Jan 9th, 2007
Use Unioin Transformation
Login to rate this answer.
Ravi
Answered On : Feb 27th, 2007
can we give string value in router..
please confirm and reply..
i think in filter its not acceptable
Login to rate this answer.
Debraj
Answered On : Apr 27th, 2013
You need to use TC here, the country names may not be known to you at prior.
Login to rate this answer.
Mahesh Manam
Answered On : May 6th, 2013
Using Router transformation we will achieve this.
S -> SQ -> RTR -> T
In router,create 10 groups for 10 countries
Login to rate this answer.
John
Answered On : May 29th, 2013
Sort all the records by country name.
in expr transformation include the below variables
v_countout=IIF((v_currcountry=vprevcountry),v_count,vcount+1)
basically incrementing the count if the country name changes.
in router create 10 groups and add the below condition
MOD(v_count,10)=1 then table 1
Mod(v_count,10)=2 then table 2
and so on.
this logic is assuming that country names are not known to us.
Login to rate this answer.
