Answer Posted / raji

Hai frnds,
According to my knoweledge,active t/f means which changes the number of rows that can pass through it.
coming to why union t/s is active.......because union t/f merges the data which is coming from two sources,it means that it summarizes the data which is passing through union t/f,with this the no.of rows coming from that will be less....
so it is an active t/f...

Thanks.....Raji

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

1407

---

Define update strategy?

631

---

Implementation methodology

1258

---

How to update a particular record in target with out running whole workflow?

1152

---

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

7784

---

---

What is mapplet in informatica?

589

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1002

---

can we override a native sql query within informatica? Where do we do it?

620

---

What are the popular informatica products?

646

---

what are the Methods For Creating Reusable Transformations?

647

---

Explain what is informatica metadata and where is it stored?

604

---

r u done any partitions in ur project?

1402

---

What does cheating measurement mean?

593

---

how to create user defined function (udf) in informatica

781

---

what is the complex transformation you used in informatica

2185

---