Answer Posted / vishnu_kr

hi,

sorry for a small mistake in the last answer

u use 'update else insert' property in the session mappings
tab.

Why union transformation is an active transformation?

1047

---

What is an active transformation?

1110

---

Does an informatica transformation support only aggregate expressions?

1042

---

tell me the rules and responsblites in our project(my project is development)

1933

---

What the difference is between a database, a data warehouse and a data mart?

1155

---

What is data transformation manager process?

1157

---

What are the popular informatica products?

1012

---

Different circumstance which drives informatica server to expel records?

983

---

How to elaborate powercenter integration service?

1133

---

How to update a particular record in target with out running whole workflow?

1576

---

What are the differences between source qualifier and joiner transformation?

1062

---

Define pmcmd command?

1043

---

What is aggregate cache in aggregator transformation?

1145

---

What is meant by query override?

1060

---

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

9135

---