Hii. this question was asked in accenture interviewIf ur having source table in which there are records of 10 different countries and ur havig 10 target tables so tell me how should we load the individual data of country in individual table.i know that we can do this using router transformation but i m not able to make it so plz can anyone help me in this.regardsTarang Jain

Questions by rajnish123   answers by rajnish123

Showing Answers 1 - 9 of 9 Answers

Sravan Kumar

  • 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 ........

  Was this answer useful?  Yes

s

  • Jan 2nd, 2007
 

U hv to giv different filter conditions in different user defined groups

eg:conutryname='India'

    countryname='USA' 

  Was this answer useful?  Yes

Infoseek

  • Jan 5th, 2007
 

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

  Was this answer useful?  Yes

Guest

  • Jan 9th, 2007
 

Use Unioin Transformation

  Was this answer useful?  Yes

Ravi

  • Feb 27th, 2007
 

can we give string value in router..

please confirm and reply..

i think in filter its not acceptable

  Was this answer useful?  Yes

Debraj

  • Apr 27th, 2013
 

You need to use TC here, the country names may not be known to you at prior.

  Was this answer useful?  Yes

Mahesh Manam

  • May 6th, 2013
 

Using Router transformation we will achieve this.

S -> SQ -> RTR -> T

In router,create 10 groups for 10 countries

  Was this answer useful?  Yes

John

  • 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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions