Answer Posted / anil

Surrogate key is a primary key which can be used for
sequence

What is the format of informatica objects in a repository?

1009

---

What is the sql query overwrite in source qualifier in informatica

1069

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8184

---

What is rank transform?

982

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1089

---

How to use procedural logic inside infromatica?

1203

---

Describe an informatica powercenter?

1109

---

Tell me about Propagate functions in informatica

912

---

What is rank index in rank transformation?

1057

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1307

---

What is the use of source qualifier?

1116

---

What is session task and command task?

1265

---

Describe expression transformation?

1112

---

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

2545

---

How to improve the performance of a session using sorter transformation?

1133

---