Answer Posted / swetha

The Designer automatically creates a RANKINDEX port for each
Rank transformation. The Informatica Server uses the Rank
Index port to store the ranking position for each record in
a group. For example, if you create a Rank transformation
that ranks the top 5 salespersons for each quarter, the rank
index numbers the salespeople from 1 to 5:

What is a repository? And how to add it in an informatica client?

1150

---

What is the difference between stop and abort in informatica

1097

---

Explain the scenario which compels informatica server to reject files?

1171

---

What is decode in static cache?

1185

---

What is a filter transformation?

1049

---

Differentiate between a database and data warehouse?

1147

---

What is a shortcut and copy in Informatica and how two are different with each other?

1199

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2147

---

How to configure mapping in informatica?

1174

---

Explain the types of lookup transformation?

1046

---

Describe an informatica powercenter?

1127

---

What is domain and gateway node?

1168

---

What is native users?

1170

---

How to implement security measures using repository manager?

1182

---

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

2554

---