Answer Posted / madhavan eyunni

Hi dilip,

Can you explain me in brief..


Madhavan eyunni

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

1865

---

Why union transformation is an active transformation?

1049

---

Define sessions in informatica etl?

1038

---

What are the reusable transformations?

1166

---

difference between repository database and repository service?

1156

---

What are the guidelines to be followed while using union transformation?

1146

---

What is sq transformation?

1163

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1167

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2038

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7395

---

What is the need of an ETL tool?

1103

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1248

---

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

1130

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1512

---

Can we create a Integration service without a Repository service and vice versa?

1215

---