Answer Posted / srikanth

HI

Among those 3 trans, filter does not use cache.

so it should be either agg or sorter.

Both agg and sorter uses cache as they process data in a
dependable fashion for performing calculations and sorting
data before the result is passed to next transfomration.

WE cant say which one uses more space. it depends on the
size of source data we are processing.

Agg needs to perform calculations on groups of data but if
the data in sorter is more, it takes more space than agg to
hold the data.

for ex, we are sorting on character data, server needs to
use ASCII values of alphabets to sort in order.

It depends on the size of the source data.

Write the program through which the records can be updated?

1054

---

What is meant by target load plan?

1028

---

What is a node in Informatica?

1086

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1917

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

2029

---

How do you load alternate records into different tables through mapping flow?

1926

---

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1150

---

Why filter transformation is an active one?

1033

---

EXL informatica Questions

1446

---

Under what condition selecting sorted input in aggregator may fail the session?

1175

---

what is diff b/t sorter t/r and agg have the option sorter property...

2231

---

Briefly define reusable transformation?

1182

---

What are the tasks that source qualifier perform?

1145

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1159

---

Explain the aggregator transformation?

1222

---