Answer Posted / shaik

PMCMD is a command line program,which provide the
communication with integration service......

if u want to run the session by using PMCMD command there
should be workflow present for the particular session

Ex:-- PMCMD> start workfolw -f <folder name> <workfolw name>

There is no command such like that start session.....

so it is not possible to run the session with out workflow....

What is flashback table ? Advance thanks

1995

---

What is mapping debugger?

1064

---

What does “tail –f” command do and what is its use as an Informatica admin.

1142

---

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

9286

---

How does a sorter cache works?

1105

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1190

---

What is the cumulative sum and moving sum?

1233

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2182

---

What is an expression transformation?

1077

---

Explain sessions?

1134

---

What are the advantages of informatica?

1053

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2120

---

COM components can be used in Informatica

2450

---

Tell me about Propagate functions in informatica

974

---

How big was your fact table

1855

---