Interested to Buy Any Domain ? << Click Here >> for more details...
In pmcmd command we need to type -p:password. Will it be
visible to others who is having access to this file ?
- 4 Answers
- 9204 Views
- Puma, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / james
How can we secure this. With out changing script file
access permissions.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / moorthy g
NO. It is not visible
For Example:
$PMDIR/pmcmd startworkflow -s ${PMSERVER} -u ${PMUSER} -p
${PMLOSEN} -f EMPSAL -wait wf_s_m_emp_sal_detail
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / pavan
Yes the password will be visible, if some one has read access to that file.
We can secure the original password by using the -pv option and by encrypting the password using pmpasswd utility of informatica..
so we will get encrypted password using pmpasswd utility and use that encrypted password in pmcmd with -pv option.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .
What did you do in source pre load stored procedure
How to improve the performance of Aggregate transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Global and Local shortcuts. Advantages.
How might you approve all mappings in the archive all the while?
Is there any model difference between ODS and DWH
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
What is source qualifier transformation in informatica?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...
In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?
Teradata 
