Answer Posted / ashok j

When we drag and drop the source table to mapping designer,
it automatically comes up with the SQ. SQ tranformation can
send the data to next level trasformation or target.

With the property Sql override, you can perform the
operations from the database level like aggregation, filter
condition, Expressions, join etc by writing appropriate
quries.

explan ur project architecture?

2073

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2061

---

Is it possible to define a single node as a Gateway node as well as worker node?

1123

---

Explain why we use partitioning the session in informatica?

1096

---

What are mapplets?

1277

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1159

---

What is the sequence generator transformation in informatica?

1184

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2139

---

lookup transformation with screenshots

4006

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1268

---

What is the maplet?

1127

---

To import the flat file definition into the designer where should the flat file be placed?

1061

---

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

---

what is mean by complex business rule ?

2162

---

How do you use reject loader.

2611

---