Answer Posted / tejeya

We can get this one by using upper(substr(name,1,1))

As union transformation gives UNION ALL output, how you will get the UNION output?

644

---

What is the function of union transformation?

618

---

What are different types of transformations available in informatica?

588

---

how to create user defined function (udf) in informatica

785

---

What is meant by target load plan?

556

---

---

What is a sorter transformation?

659

---

What are the different components of powercenter?

582

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

713

---

Can you use flat files in Mapplets.

2221

---

Can we create two repositories on same database instance in oracle?

612

---

Separate from a database, an information bazaar, and an information stockroom?

609

---

What is meant by active and passive transformation?

584

---

What is a mapplet/worklet in informatica?

689

---

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

649

---

How do you load unique records into one target table and duplicate records into a different target table?

712

---