how can run the wf through pmcmd commend? write script?
Answers were Sorted based on User's Feedback
Answer / gazulas
pmcmd startworkflow -wait -sv $INF_SERVICE -d $INF_DOMAIN -uv INF_USER -pv INF_PSWD -f $2 $1 > $PMCMD_LOGS_DIR/${1}_$DATESTAMP.log
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ravi
pmcmd startworkflow -u ${infa_etl_user} -p ${infa_etl_passwd} -sv ${infa_etl_is} -d ${infa_etl_dom} -f ${folder_name} -paramfile ${parfile} -wait $workflowname
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
how the informatica server sorts the strings values in rank transformations?
What is a snowflake schema?
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?
To achieve the session partition what r the necessary tasks u have to do?
All active transformations r passive or not?
what is the size of your data warehousing?
What are the main features of Oracle 8i with context to datawarehouse?
What is target load order?
What is the need of etl tools?
What is meant by lookup transformation? Explain the types of lookup transformation?
we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?
2 Answers Patni, Tech Mahindra,