Answer Posted / mr.lee

id sal

101 1000

102 1000

103 1000

104 1000

Select Rn, id, Sal, From (
Select Rownum Rn, id ,Sal From Emp)
Where Rn = 3

What is the maplet?

1040

---

 Informatica Checkpoints

3266

---

what are 3 tech challenges/ common issues you face?

2278

---

Name the different lookup cache(s)?

1157

---

Explain scd type 3 through mapping.

916

---

What is session task and command task?

1174

---

What is informatica powercenter repository?

1139

---

What is the Rank index port in Rank transformation?

1011

---

Is there any way to read the ms excel datas directly into informatica?

977

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1004

---

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

1129

---

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

1022

---

Do you find any difficulty while working with flat files as source and target?

1050

---

Design a mapping to load a target table with the following values from the above source?

1282

---

Explain constraint based loading in informatica

1035

---