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 does cheating measurement mean?

1042

---

How will the document be delivered to me?

1066

---

What is dynamic cache?

1027

---

What are the differences between source qualifier and joiner transformation?

1051

---

Where are the source flat files kept before running the session?

1067

---

What is the need of an ETL tool?

1078

---

What are the main features of Oracle 8i with context to datawarehouse?

2109

---

In informatica workflow manager, how many repositories can be created?

1346

---

Describe an informatica powercenter?

1120

---

Why sorter is an active transformation?

1185

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1139

---

What are the different ways to implement parallel processing in informatica?

1415

---

Explain transaction control transformation in informatica

1263

---

How many ways a relational source definition can be updated and what are they?

1011

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2153

---