Answer Posted / shiva

limitation is with the sortor cache. the following are its
limitations....
In version 8 it is set to Auto. In version v7 it is 8MB
If it cannot allocate then the session will fail
If it needs more memory that it will pages the data in the
Work Directory, and writes a warning in the log file.

let me know to what extent the answer is correct..

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1727

---

what is the -ve test case in your project.

2329

---

How can we store previous session logs?

989

---

Enlist some properties of sessions.

1021

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1740

---

Target increases every day even though no new record was inserted

1514

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1506

---

Define update strategy?

1112

---

What are the different clients of powercenter?

1006

---

draw informatica architecture 8.6 ?

3820

---

What are the types of schemas we have in data warehouse.

894

---

What is workflow? What are the components of the workflow manager?

1065

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1028

---

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2277

---

Describe the impact of several join conditions and join order in a joiner transformation?

1008

---