Interested to Buy Any Domain ? << Click Here >> for more details...
Router T/R is active but some people are saying it is also
passive which is exactly right?
- 5 Answers
- 20277 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 21 Yes | 3 No |
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,,,,,
| Is This Answer Correct ? | 15 Yes | 3 No |
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?
| Is This Answer Correct ? | 4 Yes | 0 No |
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
| Is This Answer Correct ? | 2 Yes | 0 No |
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..
| Is This Answer Correct ? | 0 Yes | 0 No |
what is mean by grouping of condition column in lookup transformation?
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
What are the main issues while working with flat files as source and as targets ?
Different qualification between a related rotate toward the sky and isolates look upward?
how to join the 2 different table with different columns in informatica?
what is meant by lookup caches?
2 Answers Cap Gemini, Informatica,
Define mapping and session?
What are the uses of a Parameter file?
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.
Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 Answers Cap Gemini, Puma, Wipro,
write a query to get maximum salary from the employers table without duplicates....kindly help me
Teradata 
