Answer Posted / prasad_bestha

source table

col1 col2
101 1-a
102 1-a,2-ab
103 1-a,2-ab,3-abc


target table
col1 col2 col3
1 101 a
2 102 a
3 102 ab
4 103 a
5 103 ab
6 103 abc

Define the various join types of joiner transformation?

990

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7462

---

What is sq transformation?

1170

---

What is the maplet?

1131

---

What is the format of informatica objects in a repository?

1021

---

How can we delete duplicate rows from flat files?

1231

---

Mention few power centre client applications with their basic purpose?

956

---

Please let me know how to make Data masking in informatica..

1733

---

What is meant by incremental aggregation?

1111

---

Define mapping and session?

1040

---

Explain about Informatica server process that how it works relates to mapping variables?

1089

---

What is informatica powercenter repository?

1207

---

Explain how to import oracle sequence into informatica?

1021

---

Why do you use Mapping Parameter and mapping variable?

1773

---

What is option by which we can run all the sessions in a batch simultaneously?

1149

---