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)

Briefly explain the aggregator transformation?

993

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

999

---

Explain the features of connected and unconnected lookup.

927

---

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

1037

---

What is xml source qualifier transformation in informatica?

1211

---

State the differences between sql override and lookup override?

1187

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2127

---

How do you update the records with or without using update strategy?

1106

---

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1068

---

Reusable transformation and shortcut differences

1836

---

How many ways are there to create ports?

1316

---

Global and Local shortcuts. Advantages.

2029

---

Explain sessions. Explain how batches are used to combine executions?

1018

---

What are the mapping parameters and mapping variables?

1174

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1083

---