Answer / rajesh.a

Hi,

Router is Active Transformation only.Take a small example.Lets say emp table is having salaries between 1000 and 2000.and no.of records of salary 1000 is 5 and no.of records of salary 2000 is 5 and no.of records of salary 1500 is 5 .
Now in Router we will create 2 groups and and conditions are 1group-salary >=1000 and salary <=1500 --will give 10 rows
2group-salary >=1500 and salary <=2000 --will give 10 rows
so input rows are 15 and output rows are 20.So there is a change in no.of.rows between input and output.So Router is active

Answer / srinu

Hi Guys,

First of all Every Active tranformation is a Passive
transformation,But every passive not Active.

In Router Transformation there is a special feature with
Default Group.Because of Default Group its Passive.
We can avoid this Default group by Some transformation
Settings,Now its Active.

any queries let me know
srinu.srinuvas@gmail.com,,,,,

Answer / manoj

@Answer2: See, you mean to say input to the router is 15
and output is 20 so router tr is active. if that is the
case, we can take one row from the expression and connect
it to two transformation, so do u say expression is also
active?

Answer / deva

AS srinu said All Active can act as passive. Active TR
means the number of rows which is the input to the
Transformation will decrease in the output from that
transformation .


For example :- i have emp table if i write a condition
where sal>2000 then the rows will decrease after this
transformation . same when i didn't apply any condition
then that acts as Passive transformation

Answer / sandeepl

If you connect default group to another T/R it is passive
T/R,B'coz If data meet user defined group condition it'll
pass throught it and remaing data pass through default
group, So, No chance to drop row in T/R it self.

Router can be Active or Passive..

what are the deliverables?in your project?

0 Answers   DELL,

what is mystery dimension?

1 Answers  

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

In a concurrent batch if a session fails, can you start again from that session

1 Answers  

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

3 Answers   CTS,

i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,

Do joiner transformation use cache? If so describe?

2 Answers   Patni,

What is the difference between procedure and stored procedur?

2 Answers   IBM,

Explain the scenario which compels informatica server to reject files?

0 Answers  

where to store informatica rejected data?

0 Answers  

What are mapplets?

0 Answers  

Where are the source flat files kept before running the session?

0 Answers   Informatica,