Interested to Buy Any Domain ? << Click Here >> for more details...
How will you display "Mr" for male & "Mrs" for female in
target table?
- 7 Answers
- 13120 Views
- I also Faced
- E-Mail Answers
Answer Posted / addy
This can be done by the Expression Transformation easily.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In informatica workflow manager, how many repositories can be created?
tell me the rules and responsblites in our project(my project is development)
What is an Integration service in Informatica?
How to extract sap data using informatica?
What is session task and command task?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are connected or unconnected transformations?
Is it possible to define a single node as a Gateway node as well as worker node?
What are the differences between joiner transformation and source qualifier transformation?
can anyone explain me about retail domain project in informatica?
What is target load order?
What is the meaning of up gradation of repository?
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
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
