Answer Posted / shekar

After source qulifier add a expression transformation in
the expression transformation create out put port name it
as maxsal then derive the code for this out put port as
setmaxvariable(sal).
Then pass the output ports from expression to target table.

What are the data movement modes in informatica?

1210

---

How many dimensions are there in informatica?

1135

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1141

---

Is stop and abort are same in informatica?

1048

---

What are the types of presistent cache in look up tr.

2105

---

Write the program through which the records can be updated?

1055

---

How to extract sap data using informatica? What is abap? What are idocs?

1253

---

is it possible to index the data in cache of lkp transformation ?

2078

---

What is a filter transformation?

1094

---

How might you approve all mappings in the archive all the while?

1085

---

How can we use mapping variables in informatica?

1125

---

server hot-ws270 is connect to Repository B. What does it mean?

2654

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1063

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1128

---

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

1910

---