Answer Posted / chandu

In Expression transfermation, if( sales = q1,sales,0)

How can you increase the performance in joiner transformation?

1133

---

In informatics server which files are created during the session rums?

1063

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1805

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

915

---

What is enterprise data warehousing?

987

---

Global and Local shortcuts. Advantages.

1957

---

How identifying bottlenecks in various components of informatica and resolving them?

1055

---

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

8937

---

How to partition the Session?

1040

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

982

---

Why filter transformation is an active one?

929

---

explain abt ur project architecture?

2122

---

Under what condition selecting sorted input in aggregator may fail the session?

1057

---

What all are steps in up gradation of Informatica server?

988

---

Explain target update override in informatica

1043

---