what are the unix commands to start the wrk flow ?
Answer Posted / chandra
pmcmd startworkflow -service ${INFA_SERVICE} -domain
${INFA_DOMAIN} -uv xxx_PMCMD_ID -pv PSWD -folder
${ETLFolder} -wait ${ETLWorkflow} \
| Is This Answer Correct ? | 16 Yes | 3 No |
Post New Answer View All Answers
What are the data movement modes in informatica?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Describe expression transformation?
Mention few advantages of router transformation over filter transformation.
Explain why we use partitioning the session in informatica?
What is the difference between stop and abort in informatica
What is a shortcut and copy in Informatica and how two are different with each other?
On which transformations you created partitions in your project?
What are the static cache and dynamic cache in informatica?
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
Differentiate between a repository server and a powerhouse?
Separate from a database, an information bazaar, and an information stockroom?
What do you understand by a term domain?
What are ETL Tools?
What is meant by query override?