Answer Posted / srikanth

hi haritha

u r correct

For using sorted input option, the order of group by ports
in the agg and sorter transfomratoins should be same as
well as the number of ports also same.

we can filter out data early in the morning by using sq
trans rather than using filter before agg hence reducing
unwanted data in teh mapping.

Where can we find the throughput option in informatica?

996

---

What is the function of look up transformation?

1054

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2094

---

What is the commit type if you have a transaction control transformation in the mapping?

969

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2237

---

difference between repository database and repository service?

1081

---

Explain incremental aggregation in informatica

1064

---

how to load rows into fact table in data warehouse

1114

---

Could you explain what is enterprise data warehouse?

1047

---

What is meant by active and passive transformation?

1031

---

How can one identify whether mapping is correct or not without connecting session?

1368

---

How to handle decimal places while importing a flatfile into informatica?

1130

---

What are the performance considerations when working with aggregator transformation?

1094

---

How can we use mapping variables in informatica?

1001

---

What is an aggregator transformation?

1030

---