Answer Posted / chhaya

Hi I am Chhaya. Can you send me dumps on
chhaya.dongre@capgemini.com.

thanks In Advance dear :)

How do we call shell scripts from informatica?

1131

---

What do you mean by blocking transformation?

1054

---

How to configure mapping in informatica?

1179

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5803

---

How can we improve session performance in aggregator transformation?

1125

---

How to start a workflow using pmcmd command?

1259

---

What is domain and gateway node?

1173

---

define galaxy repository in informatica

2238

---

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

9152

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2176

---

What does command task mean?

1159

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2151

---

How do you load first and last records into target table?

1163

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1109

---

Why do you use Mapping Parameter and mapping variable?

1776

---