Answer Posted / amedela chandra sekhar

If u devlope the session in work flow manager that is
standlone session.that is not reusable first.we can't
achieve if you create session in work flow.

What are batches?

1091

---

Write the program through which the records can be updated?

998

---

What is aggregator transformation in informatica?

938

---

What are the differences between oltp and olap?

969

---

Separate from a database, an information bazaar, and an information stockroom?

1083

---

What is a surrogate key?

1077

---

How do you take back up of repository?

1158

---

What is meant by lookup transformation?

1095

---

where to store informatica rejected data?

1093

---

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

9109

---

How union transformation is used?

1002

---

what is degenerated dimension?

3985

---

Can you use flat files in Mapplets.

2648

---

Mention some types of transformation?

1040

---

What are the different types of repositories created using informatica?

1122

---