Answer Posted / raj

Muni Reddy garu

maping parameter and workflow vaariable are declared with $$ only(according to my opinion)

Is there any target staging area in informatica not staging area

2507

---

Explain the types of lookup transformation?

978

---

What is joiner transformation in informatica?

993

---

What are the new features of Power Center 5.0?

1699

---

Enlist some properties of sessions.

1020

---

What is depict expression change?

1028

---

Name the different lookup cache(s)?

1158

---

What is mapping debugger?

944

---

How many number of sessions can one group in batches?

1093

---

What is lookup change?

986

---

difference between informatica 8.1.1 and 8.6

3626

---

Can we create multiple integration service on single repository?

1133

---

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

8938

---

Enterprise data warehouse your projects phase by phase explain?

1856

---

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

1029

---