Answer Posted / abhinaw prakash

Pre session and post session.

Example: if we want to use bulk mode loading on index tables
it'll fail.

So its something like we can drop the index in pre session
command and again recreate the indexes once the data has
been loaded in post session.

Define the various join types of joiner transformation?

961

---

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

1679

---

How to elaborate powercenter integration service?

1090

---

How do you load alternate records into different tables through mapping flow?

1820

---

What are the informatica performance improvement tips

1038

---

Explain constraint based loading in informatica

1055

---

What are the settings that you use to configure the joiner transformation?

1019

---

Can we override a native sql query within informatica?

998

---

How do you use reject loader.

2558

---

Explain sessions. Explain how batches are used to combine executions?

966

---

Separate from an archive server and a powerhouse?

919

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2086

---

Differentiate between sessions and batches?

976

---

During the running session, output files are created by informatica server. Enlist few of them.

947

---

What is meant by LDAP users?

1133

---