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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is stop and abort are same in informatica?

568


scenario where i can use only concurrent execution of workflow.

2536


What are the different versions of informatica?

672


What is standalone command task?

704


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1528






what is the -ve test case in your project.

1846


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

548


tell me the rules and responsblites in our project(my project is development)

1493


What do you understand by SOA of Informatica?

583


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

596


What is the commit type if you have a transaction control transformation in the mapping?

649


What are the basic requirements to join two sources in a source qualifier transformation using default join?

609


CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

7783


Target increases every day even though no new record was inserted

1103


How can we remove the duplicates from flat file source?

572