Answer Posted / mahesh manam

For different source and different target you can make all
the mappings in ONE mapping.
And create a session for that mapping and you can call it.
If you have any constraints to load from particular target
and than some other target like wise any priority than
mention target load in mapping level
(Mappings --> target load plan --> give your priority)

What is aggregate cache in aggregator transformation?

1197

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

1136

---

What is the reusable transformation?

1098

---

How can a transformation be made reusable?

1222

---

have u done any performance tuning? how u ll do?

2362

---

can we override a native sql query within informatica? Where do we do it?

1162

---

What is Data Caches size?

1127

---

tell me 5 session failure in real time how can you solve that in your project?

2387

---

How can we store previous session logs?

1132

---

What are the uses of etl tools?

1175

---

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

1907

---

How to generate sequence numbers using expression transformation?

1145

---

Describe the impact of several join conditions and join order in a joiner transformation?

1111

---

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

2182

---

Mention a few design and development best practices for informatica?

1042

---