In pmcmd command we need to type -p:password. Will it be
visible to others who is having access to this file ?
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 |
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
What is A cache?
What is a stored procedure transformation?
Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
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...
What are the different transaction levels available in transaction control transformation?
guys which is the best institute in banglore to learn informatica??
How do you load only null records into target?
what is the method of error handling when session is running?