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 are the static cache and dynamic cache in informatica?

1153

---

Can we get 1st record through Informatica(without sequence number).

1431

---

Define filter transformation?

1048

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2102

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2144

---

What is the use of code page?

1034

---

In warehouses how many schemas are there?

1029

---

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

928

---

Explain the features of connected and unconnected lookup.

895

---

How big was your fact table

1762

---

Define mapplet?

979

---

In informatics server which files are created during the session rums?

1088

---

What is complex mapping?

1081

---

Is it possible to create multiple domains on a single Informatica server?

1199

---

What does “tail –f” command do and what is its use as an Informatica admin.

1047

---