Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / amedela chandra sekhar
Ya, Its Possible using pmcmd Command without using the
workflow Manager run the group of sessions.
It is possible to run two sessions only (by pre-session,
post session) using pmcmd without using workflow. Not more
than two.
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
Enlist the various types of transformations.
How do you set a varible in incremental aggregation
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 the surrogate key?
What is the status code in stored procedure transformation?
Where is metadata stored?
What are the modules in Power Center
What do you understand by SOA of Informatica?
Write the advantages of partitioning a session?
What is the function of union transformation?
Why update strategy and union transformations are active? Explain with examples.
How would you join a node to the already existing domain?
Does an informatica transformation support only aggregate expressions?
What is Data Caches size?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
