Answer Posted / kshetra

using verbose data in the session properties

Global and Local shortcuts. Advantages.

2080

---

How to do the error handling of if ur source is flatfiles?

2010

---

What is an Integration service in Informatica?

1182

---

What is pmcmd command?

1173

---

Explain informatica architecture - version 8 / 9

1139

---

can u give example for factless fact table

6759

---

Explain what are the different versions of informatica?

1143

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10723

---

What are the types of caches in lookup?

1094

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1551

---

How to load data in informatica ?

1063

---

Differences between version 7.x and 8.x.

1933

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1213

---

How is union transformation utilized?

1054

---

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

9280

---