Answer Posted / sumankumar

type2 scd it wil maintain historical informtion + currnt
information along with 3 options .....
1.effective date
2.version number
3.flag value

How many ways are there to create ports?

1329

---

Define Pmrep command?

1055

---

What are the main issues while working with flat files as source and as targets ?

1153

---

Separate from an archive server and a powerhouse?

960

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1061

---

Explian the Process of deployment groups in informatica

1062

---

To import the flat file definition into the designer where should the flat file be placed?

1059

---

What is decode in informatica?

1152

---

What is blocking transformation?

1142

---

Can u generate reports in Informatica?

1085

---

How to open an older version of an object in the workspace?

1203

---

How does a sorter cache works?

1068

---

What is standalone command task?

1313

---

How we can create indexes after completing the load process?

1158

---

can you please explain me pre session and post session options?

7562

---