Answer Posted / czarabid

it's very simple the question is to delete the duplicated
records and it's solution is here
DELETE FROM TABLE_NAME1 t1 WHERE ROWID </> any(SELECT ROWID
FROM TABLE_NAME1 t2 WHERE t1.column1=t2.column1);
this will delete only the redundant records leaving only one
copy of the same records in the table.
If you want to delete all the records which are redundant
then the solution is here
DELETE from table_name1 t1 where rowid <> any (select rowid
from table_name1 t2 where t1.no=t2.no)

What are mapplets? How is it different from a Reusable Transformation?

1030

---

What is pmcmd command?

1044

---

Can informatica load heterogeneous targets from heterogeneous sources?

1115

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1573

---

can u any challenge your project?

1971

---

What is the session task and command task?

986

---

What is the format of informatica objects in a repository?

972

---

How to extract the informatica rejected data?

1160

---

Which are the different editions of informatica powercenter that are available?

971

---

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

1661

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1106

---

What are the new features of Power Center 5.0?

1698

---

What is incremental aggregation?

1011

---

What is the difference between a connected look up and unconnected lookup?

910

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5678

---