Why join is faster than subquery?

593

---

What is ipconfig?

247

---

How to create a job?

5

---

What must you do if you have assets (functional locations) with the same number in several plants?

472

---

What is difference between secondary namenode, checkpoint namenode & backupnode?

244

---

---

What is Database testing and What are ways of writing test cases for database testing?

568

---

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

7757

---

How to create ​​Tcode for EPM scenario?

54

---

Tell about fiscal Deficit and budgetary deficit?

598

---

How do I fix isdone error?

445

---

Why cannot we use leds for rectification purpose?

552

---

What is Cassandra Data Modelling ?

59

---

What significant trends do you see in the future for our industry?

598

---

how does multithreading take place on a computer with a single cpu? : Java thread

684

---

Which database management system is used in wordpress by default?

142

---