Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Differentiate between router and filter transformation?
Explain transaction control transformation in informatica
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
Which is the t/r that builts only single cache memory?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Differentiate between source qualifier and filter transformation?
Why update strategy and union transformations are active? Explain with examples.
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Difference between Data and Index Caches?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is Index Caches size?
What is parallel processing in informatica?
What are junk dimensions?
How do you handle two sessions in Informatica
