Answer Posted / rajkumar bachu

1)Bulkload & Narmal load

Normal: In this case server manager allocates the
resources(Buffers) as per the parameter settings. It creates
the log files in database.

Bulk: In this case server manager allocates maximum
resources(Buffers) available irrespective of the parameter
settings. It will not create any log files in database.

In first case data loading process will be time taking
process but other applications are not affected. While in
bulk data loading will be much faster but other application
are affected.

What is a transaction control transformation?

1264

---

Enlist some properties of sessions.

1136

---

What are pre and post-session shell commands?

1389

---

What is the difference between stop and abort in informatica

1144

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2087

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1081

---

What is the use of transformation?

1056

---

What is mapplet in informatica?

1129

---

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

1241

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2293

---

How to delete duplicate row using informatica?

1090

---

Differentiate between sessions and batches?

1070

---

Plz can any one say me how to get the informatica certification materials and dumps

2101

---

what are the deliverables?in your project?

2196

---

What is the difference between a connected look up and unconnected lookup?

1003

---