Answer Posted / chandrasekar
Using PMCMD command is used to communicate an Intergration
services.
Using the PMCMD>connect -sv services -d domain -u username
-p password.
the above one is syntax for used connet to an Intergration
services.
PMCMD>startworkflow -f foldername workflow_name.
It is used to execute the worflows.
If it is wrong means please mail to me chandranmca2007@gmail.com
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Write the advantages of partitioning a session?
What is the sequence generator transformation in informatica?
whats the logic to load the lower level of granularity of data to fact table.
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
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is primary and backup node?
Define sessions in informatica etl?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
server hot-ws270 is connect to Repository B. What does it mean?
Is there any way to read the ms excel datas directly into informatica?
Is stop and abort are same in informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How to delete duplicate row using informatica?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is joiner change?