Can yoU use the maping parameters or variables created in
one maping into another maping?
Answers were Sorted based on User's Feedback
Answer / swetha
NO. We can use mapping parameters or variables in any
transformation of the same maping or mapplet in which yoU
have created maping parameters or variables.
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / pramod bm
You can use the mapping parameters/variables in other mappings also but only with the help of reusable transformation. If it is not a reusable transformation then you cannot use parameters/variables in other mappings.
| Is This Answer Correct ? | 0 Yes | 0 No |
when informatica 8 series released ?
is it possible to index the data in cache of lkp transformation ?
select count(1) from emp? what is the o/p?
How does the session recovery work.
without matching columns in two tables. how can you join
What are mapping parametres and variables in informatica?
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
What is standalone command task?
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
Is it possible to define a single node as a Gateway node as well as worker node?
How many ways you create ports?
how to run workflow in unix?
5 Answers Colgate, HP, Tech Mahindra,