Answer Posted / kal_leo@hotmail.com

Hi U can eliminate duplicate records by an simple oneline
SQL Query.

select id, count(*) from seq1 group by id having
count(*)>1;

U can run this query directly on any SQL*Plus or U can
override SQL in any transformation.

Hope this is of any help.

Kal

can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

1933

---

diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

2317

---

What are the etl testing operations includes?

814

---

Explain about power designer data modeling software?

632

---

flat filevalidation in informatica

1924

---

What is Data Vault???

2520

---

Can we create Hierarchies in generic datasources?

2120

---

Identifying the bottlenecks in various components of Informatica and resolving them.

2391

---

What is staging area referring to?

801

---

what is pmrep command?

11152

---

dimension object created in oracle can be imported in designer?how?

2683

---

How to fine tune mappings?

732

---

what is an ETL or ETT? And what are the different types?

7205

---

State the differences between shortcut and reusable transformation

749

---

Explain about etl data integration software?

670

---