Answer Posted / santosh

1.If you have duplicate data then you can use sorter or aggregator transformation to remove duplicate.
2. If u want to delete record after 50 the row then u can use sequence genetor.
3. Write the result to a other flat file as target.
4. Use 'Post session success command' in component tab of session task to delete the old flat file and rename the target flat file to old flat file.

Please correct me if this is wrong
Thanks and regards
Santosh Kumar Sarangi

How to go to the older version for a mapping?

1027

---

How many transformations can be used in mapplets.

1867

---

Please let me know how to make Data masking in informatica..

1661

---

Could you explain what is enterprise data warehouse?

1042

---

How we can create indexes after completing the load process?

1106

---

Partition, what happens if the specified key range is shorter and longer

2432

---

How many dimensions are there in informatica?

1022

---

Explain lookup transformation source types in informatica

1039

---

What are the static cache and dynamic cache in informatica?

1138

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2020

---

Differences between connected and unconnected lookup?

1122

---

What is the use of target designer?

980

---

What is standalone command task?

1256

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1840

---

How is union transformation utilized?

948

---