Interested to Buy Any Domain ? << Click Here >> for more details...
By using Filter Transformation,How to pass rows that does
not satisfy the condition(discarded rows) to another target?
- 14 Answers
- 48375 Views
- CSC, Emphasis, I also Faced
- E-Mail Answers
Answer Posted / sandeepbabu
in router transformation:Each row will be input for router transformation.
IF Row is TRue:for Uesr defined group condtion the data passes to the next transformation or target table,
IF Row is Flase:Uesr defined group condtion data will be passes to default group in router transformation
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
I have a flat file, want to reverse the contents of the flat file
What is the benefit of partitioning a session?
What is the reusable transformation?
What is fact table? Explain the different kinds of facts.
What do you mean by blocking transformation?
What is exclusive and normal mode for repository services?
How to update or delete the rows in a target, which do not have key fields?
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
how we can load rejected record's at run time?(not through bad files)
Differences between connected and unconnected lookup?
define galaxy repository in informatica
What is target designer and target load order?
What are the prerequisite tasks to achieve the session partition?
Describe an informatica powercenter?
