Answer / ram

Filter-----------------------------Router

1.Single condition 1. Multiple condition
2.Single Target 2. Multiple Targets
3.If the rows doestnot Match 3. Default Port
means rows will be Discards.

Answer / ashish a

first the Similarity between Router and Filter is

-Both transformation would able to discard data based on
some filter condition.

The Differences are...
1.Using router transformation one would able to test
incoming data for multiple filter condition and if none of
the condition met the incoming rows gets reouted to DAFAULT
group.

2.Using filter transformation one would able to pass data
to next transformation based on single filter pipeline
condition.There is no option of routing data that doesnt
match the condition like ROUTER Transformation.

Answer / xxx

filter: it drops the data that do not meet the condition
Router:it has an option to capture the data that do not
meet the condition

Answer / naresh araveti

the difference b/w filter and router is that fiter works on
single conditon & wherein router works with mulpile
condition & it also can poolup up discarded data..

Answer / thava

Filter =One condition
Router=More than one condition
When you have more than one condition to be checked we can
use more than one filter for each condition but it is time
consuming,so router is the best transformation to be used
there instead of multiple filter transformations.

Answer / hari

->filter allows single conditions where as router allows
multiple conditions
->filter connected to a single target where as router
concted to multiple targets
->filter do not capture the rejected records where as router
capture rejected records and store into the default out put

Answer / saradhi

Filter is like an where condition.
its having only one condition and its not having default
data.
In Router its having multiple condtions and its maintain
the default data also.

Answer / bhanu prakash

->filter transformation is used for only one condition
where as router transformation is used for multiple conditions

->in filter transformation there is only one target,where as
in router transformation there is more than one targets.

-> filter is like where condition in SQL
router transformation is like SUB Query in SQL

Answer / jang

If we what to test for multiple conditons, then we need to
have multiple Filters TRN's, so each filter TRN scans the
data. Where as in Router TRN data is only once scan or read
to evaluate the conditions, so the performance may be good
with router.

Answer / srinivas

1.Filter will removes unwanted data based on a filter
condition,if we want use multiple filter conditions using
filter it is not possible,so we have another option i.e router.
2.Router:advantage is one input can be passed and based
on filter conditions output will be get,here matched
condition and un-matched condition records can be get

I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

6 Answers   IBM, TCS,

what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,

Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?

1 Answers  

What is a poling?

2 Answers  

How to load time dimension?

1 Answers   Ford,

I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..

2 Answers   DELL,

what are the row and column separations in Flat Files

3 Answers   CTS,

What are active transformations? Name them.

1 Answers  

in reporting we add some new objects,how we get the count of the newly added objects to the report

0 Answers   HP,

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

4 Answers   TCS,

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

2 Answers   IBM,

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,