Explain pushdown optimization and types in informatica

0 Answers   Informatica,

---

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

4 Answers   CSC,

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

---

What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,

---

I have 1200 records how can u send it in aggregator with good performance issues?

3 Answers  

---

How to compare Source and Target table, without using dynamic lookup?

4 Answers  

---

What is the advantage of informatica?

0 Answers  

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.

1 Answers   DELL,

---

How can we improve session performance in aggregator transformation?

0 Answers   Informatica,

---

How union transformation is used?

0 Answers  

---

Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,

---

what is the difference between lookupoveride and joiner?

3 Answers  

---