Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vijay
except source qualifier tranformation,all transformations
supports reusable property.reusable transformation
developed in two ways.
1.in mapping which transformation do you want to re
use,select the tranformation and double click on it,there
you got option like make it as reusable transformation
option.there you need to check the option for converting
non reusable to reuasble transformation.but except for
source qualifier trans.
2.by using transformation developer
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
Is it possible to define a single node as a Gateway node as well as worker node?
Could you explain what is enterprise data warehouse?
What is decode in informatica?
How to go to the older version for a mapping?
How to load last n records of file into target table - informatica
Explain informatica architecture - version 8 / 9
What does update strategy mean, and what are the different option of it?
What is informatica metadata and where is it stored?
How to start a workflow using pmcmd command?
Where are the source flat files kept before running the session?
Is it possible to revert a global repository to local one and why?
Explain Dataware house architecture .how data flow from intial to end?
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
Repository user profiles
How can informatica be used for an organization?
