Router T/R is active but some people are saying it is also
passive which is exactly right?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you convert single row from source into three rows into target?

599


What is the use of target designer?

602


What is the cumulative sum and moving sum?

752


What is mapping debugger?

568


What is meant by LDAP users?

687






How do you set a varible in incremental aggregation

1440


How might you approve all mappings in the archive all the while?

599


what is Active lock explain

2365


What is a transaction control transformation?

761


What do you mean incremental aggregation?

621


Explain sessions?

602


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1465


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

629


What is the benefit of partitioning a session?

621


what is the -ve test case in your project.

1846