Answer Posted / srinivas

we can do by using rank transformation also
select rank as 1 top or bottom what ever the ur requirement
and select the group by port for the duplicate column

What is meant by LDAP users?

1285

---

Enlist the tasks for which source qualifier transformation is used.

1073

---

What do you understand by term role-playing dimension?

1116

---

What are the performance considerations when working with aggregator transformation?

1202

---

What is the way to execute pl/sql script using informatica mapping?

1681

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2168

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6580

---

what are the Methods For Creating Reusable Transformations?

1253

---

How to improve the performance of a session using sorter transformation?

1186

---

In informatics server which files are created during the session rums?

1165

---

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1097

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1144

---

Is stop and abort are same in informatica?

1046

---

How can you define user defied event?

1073

---

Could you explain what is enterprise data warehouse?

1224

---