Answer Posted / sarvesh

in aggregator
data cache size is:
no.of groups(sigma(colomnsize)+7)and same for index
cache also

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1815

---

What are the informatica performance improvement tips

1149

---

How can informatica be used for an organization?

1271

---

What is decode in static cache?

1259

---

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

1161

---

Explain about cumulative Sum or moving sum?

1090

---

What do you mean by blocking transformation?

1115

---

Explain the mapping variable usage example in informatica

1224

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2246

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1218

---

What are the settings that you use to configure the joiner transformation?

1099

---

What does reusable transformation mean?

1192

---

Tell me about MD5 functions in informatica

980

---

Where do we use mapping variables in informatica?

1118

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2085

---