Answer Posted / chandra sekhar

1. lookup can be configured as active transformation
2. We can write SQl override on the uncached lookup. Earlier
we can do this only on cached lookup.
3. We can increase the size of the Session log file.
4. **** Database resilience feature: If the session overcome
a database dead lock it will not fail the session
immediately it will retry again and we can configure the no
of times we wanted the integration service to retry.

What is native users?

1225

---

What is the meaning of decode in informatica?

1165

---

What is source qualifier transformation in informatica?

1066

---

What is a rank transform?

1146

---

What are the different transaction levels available in transaction control transformation?

1275

---

Explain Dataware house architecture .how data flow from intial to end?

2650

---

Why is sorter an active transformation?

1198

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

1069

---

Explain how many types of dimensions are available in informatica?

1173

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1231

---

How many input parameters can exist in an unconnected lookup?

1604

---

Why do you use Mapping Parameter and mapping variable?

1809

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2170

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10729

---

What are the guidelines to be followed while using union transformation?

1207

---