How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

7 Answers   iNautix,

---

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

0 Answers   IBM,

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

0 Answers  

---

Informatica and datawarehousing courses in Pune?

2 Answers  

---

in which situations do u go for scds ?

3 Answers   TCS,

---

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---

Does an informatica transformation support only aggregate expressions?

0 Answers  

---

Define update strategy?

0 Answers  

---

From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,

---

WHat all joins are there in Source Qualifier?

1 Answers  

---

What is rank transformation?

0 Answers  

---

What are the data movement modes in informatica?

0 Answers   Informatica,

---