Answer Posted / murugan

only use the Aggregator function.....

first(sal>=values)

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

716

---

Explain what are the different versions of informatica?

655

---

What is the sql query overwrite in source qualifier in informatica

619

---

Explain sql transformation in script mode examples in informatica

605

---

How can we improve session performance in aggregator transformation?

674

---

---

what is the size of your data warehousing?

1671

---

What is Data Caches size?

656

---

What are the different clients of powercenter?

602

---

What do think which one is the better joiner or look up?

728

---

How many numbers of sessions can one group in batches?

623

---

What are the modules in Power Center

1238

---

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

649

---

How do you update the records with or without using update strategy?

664

---

Name the different lookup cache(s)?

710

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1776

---