Answer Posted / yamini

Hi,

we can pass the date values in mapping parameter. why because as the column values are constant so we can pass that values in expression by creating output ports.

So after exp transformation put a normalizer with occurrence 2. after normalizer put an exp to convert date into week by to_char function

What is the way to execute pl/sql script using informatica mapping?

1582

---

How big was your fact table

1785

---

What is a shortcut and copy in Informatica and how two are different with each other?

1186

---

What is a code page?

1159

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

2272

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1890

---

How to handle decimal places while importing a flatfile into informatica?

1179

---

What is a repository? And how to add it in an informatica client?

1128

---

What are active transformations.

1639

---

Difference between Target-based loading and constraint-based loading?

983

---

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

9068

---

Which is the t/r that builts only single cache memory?

1177

---

During the running session, output files are created by informatica server. Enlist few of them.

969

---

Briefly explain the aggregator transformation?

985

---

Under which circumstances, informatica server creates reject files?

1075

---