Answer Posted / santoshi

Using Command task in the workflow

What is a predefined event?

1093

---

r u done any partitions in ur project?

1827

---

What is the Process to creating lookup transformation in informatica

1043

---

How big was your fact table

1803

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1081

---

What is union transformation in informatica?

1146

---

What is InformaticaPowerCenter?

1136

---

Is stop and abort are same in informatica?

1001

---

Explain how to import oracle sequence into informatica?

1011

---

Where do we use mapping variables in informatica?

1065

---

What is event and what are the tasks related to it?

1122

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5675

---

In informatica workflow manager, how many repositories can be created?

1361

---

Explain Dataware house architecture .how data flow from intial to end?

2582

---

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

9131

---