Answer Posted / sudheer

maximum size of conventional databases(legacy systens) can
be specified as 512PB(Peta Byte=(10^15)).
but,maximum size of a data ware house cannot be specified.
it depends on the memory of number of systems connected to
the server!!
we can expect that the maximum size will be definitely
thrice the max size of DB i.e., 512pb.

so, max size of a data ware house will be >= (3*512=1536pb)

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1980

---

What do you understand by term role-playing dimension?

985

---

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

905

---

What are mapplets?

1218

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1936

---

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2258

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

984

---

Explain sessions?

987

---

Enlist few areas or real-time situations where informatica is required.

1026

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7120

---

What is standalone command task?

1267

---

What is Index Caches size?

1056

---

What are the new features of informatica 9.x at the developer level?

989

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1042

---

What is a connected transformation?

1055

---