Answer Posted / ram

1. Full Cache
2. Part Cache
3. No Cache

What are the types of data warehouses?

1577

---

What do you understand by SOA of Informatica?

1044

---

What are the different versions of informatica?

1337

---

Can you use flat files in Mapplets.

2715

---

How do you take back up of repository?

1209

---

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

9302

---

How do you update the records with or without using update strategy?

1164

---

What are data-driven sessions?

1261

---

What if the source is a flat-file?

1170

---

Explain sql transformation in script mode examples in informatica

1211

---

How can we handle two sessions in informatica?

1095

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2404

---

What are session parameters ? How do you set them?

1901

---

Briefly explain the aggregator transformation?

1068

---

Define joiner transformation?

1107

---