How to create view in stored procedure sql server?

25

---

main roll of network administrator

897

---

Define mongodb SUM?

1

---

How can you create anonymous subroutines?

63

---

explain end to end scenario's for online Money transfer in Banking Domain?

734

---

---

How a soap message is structured?

30

---

How many sorting are there in data structure?

17

---

How do I align columns in word?

11

---

What is a serial queue?

29

---

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

6067

---

What is the difference between primary ecological succession and secondary ecological succession?

11

---

Explain the four types of container that the j2ee specification defines

41

---

Which of the following commands can be run in bootstrap mode?

33

---

What is a sessionfactory? Is it a thread-safe object?

58

---

What is job tracker role in hadoop?

1

---