Answer Posted / amedela chandra sekhar

If two flat files are having same structure then we can join
by using Union transformation.








Chandu

Is it possible to revert a global repository to local one and why?

1023

---

Describe an informatica powercenter?

1035

---

What is the reusable transformation?

1006

---

How can we handle two sessions in informatica?

982

---

What is the benefit of partitioning a session?

1102

---

How we can create indexes after completing the loan process?

1142

---

How many ways a relational source definition can be updated and what are they?

952

---

What are pre and post-session shell commands?

1236

---

What is a filter transformation and why it is an active one?

906

---

Write the unconnected lookup syntax and how to return more than one column.

1049

---

What do you understand by a term domain?

1062

---

Explain dynamic target flat file name generation in informatica

1008

---

Explain the different lookup methods used in informatica?

972

---

Explain constraint based loading in informatica

1037

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2508

---