Answer Posted / davankumar

select name,sal,(select max(sal) from t1) from t1

Which transformation is needed while using the Cobol sources as source definitions?

1123

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1846

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8170

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1727

---

What all are steps in up gradation of Informatica server?

988

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1079

---

What is joiner transformation in informatica?

993

---

What are the features of complex mapping?

1096

---

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 is resilience time?

1047

---

What does reusable transformation mean?

1069

---

explain about unit testing? in real time?

2133

---

How can we delete duplicate rows from flat files?

1162

---

lookup transformation with screenshots

3939

---

How do you convert single row from source into three rows into target?

1090

---