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

what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

2124

---

What are the different Lookup methods used in Informatica?

919

---

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

2619

---

Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.

1807

---

Explain about etl data integration software?

889

---

What is etl process?

937

---

what is session partitioning?

1880

---

What is data modeling and data mining?

975

---

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

2187

---

how do u really know that paging to disk is happening while u are using a lookup transform?

1986

---

When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

977

---

list and discuss two approaches for updation of target table in Informatica and how they are different.

2110

---

what are the facilities provided by data warehouse to analytical users?

2081

---

What are the etl testing operations includes?

1111

---

Explain the use lookup tables and Aggregate tables?

977

---