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
Is stop and abort are same in informatica?
scenario where i can use only concurrent execution of workflow.
What are the different versions of informatica?
What is standalone command task?
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
what is the -ve test case in your project.
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?
tell me the rules and responsblites in our project(my project is development)
What do you understand by SOA of Informatica?
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?
What is the commit type if you have a transaction control transformation in the mapping?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
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
Target increases every day even though no new record was inserted
How can we remove the duplicates from flat file source?