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.

what is the -ve test case in your project.

2392

---

what is unit testing?tell me proceedure

2202

---

What is an active transformation?

1080

---

Explain pmcmd command usage in informatica

1107

---

How to update or delete the rows in a target, which do not have key fields?

1166

---

Mention few power centre client applications with their basic purpose?

931

---

What do think which one is the better joiner or look up?

1191

---

What is different between the data warehouse and data mart?

1043

---

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

999

---

wf dont have integration severances how you can run?

1925

---

Target increases every day even though no new record was inserted

1562

---

Briefly define a session task?

1105

---

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1475

---

tell me the rules and responsblites in our project(my project is development)

1918

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2336

---