What is the Router transformation?
Answers were Sorted based on User's Feedback
Answer / swetha
A Router transformation is similar to a Filter
transformation because both transformations allow you to
use a condition to test data. However, a Filter
transformation tests data for one condition and drops the
rows of data that do not meet the condition. A Router
transformation tests data for one or more conditions and
gives you the option to route rows of data that do not meet
any of the conditions to a default output group. If you need
to test the same input data based on multiple conditions,
use a Router Transformation in a mapping instead of creating
multiple Filter transformations to perform the same task.
Is This Answer Correct ? | 19 Yes | 1 No |
Answer / manjunath
Router transformation is a active and connected transformation,
It is used to test multiple conditions in which it has two groups 1.Input group 2. output group . In router transformation
rejected rows will be sent to default group where we dont have in filter t/f. Router t/f is connected to multiple targets.
Let me know if iam wrong
Is This Answer Correct ? | 5 Yes | 4 No |
in a table it has 200 rows the query is select 150 from tablename.whats the output
What is mapplet in informatica?
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
What is parameter file?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
what is a time dimension? give an example?
what is system requirement(SR) & business requirement(BR)?
i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same