Answer Posted / maxy

I think it's better to have a null check here in the exp
before aggregating.
If salary is Null for any employee it will not be consider
while caculating the avg.
ex-
epm sal
e1 10
e2 20
e3
e4 30

Though there are four employee avg will be 20.

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2064

---

How can we create index after completion of load process?

1122

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2033

---

Enlist some properties of sessions.

1065

---

What is sequence generator transformation in informatica?

1077

---

How are indexes created after completing the load process?

1641

---

define galaxy repository in informatica

2225

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2012

---

What are the types of caches in lookup? Explain them.

969

---

Explain the different lookup methods used in informatica?

1042

---

What is data caches/ index caches?

1100

---

How to elaborate tracing level?

1175

---

What is a grid in Informatica?

1069

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1504

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1793

---