Answer / jakka

Below are the ways to eliminate the duplicate records:
1.Select distinct in source qualifier
2.Based on your requirement,select and give number of
sorted ports in source qualifier and need to override the
query using order by cluase. Then use aggregator and select
sorted input as given and use group by ports
3. Use sorter to sort data and then use aggregator as
mentined in point 2.
4.Use sorter to sort data and check distinct in soter
properties.

Hope this will help you...

Jakka

Answer / 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

Answer / vikram

To eliminate duplicate we use Source,Source qualifier,Look
up T/N, router T/N AND Target.. In This Case we use dynamic
cache


BUT USE
example emp table consist of i.d salary,name dept no.
eliminating the duplicates of dept no.

Source,Source Qualifier,Sorter T/N,Expression T/N,Router T/N
And split target in to two as duplicates and distinct
we have to create 3attributes in expression T/N AS
V_pre_deptno v_flag 0_flag
give condition as v_pre_dept no = dept no
v_flag= IFF(dept no = v_pre_deptno,1,0)

I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way

2 Answers  

---

What is a mapping, session, worklet, workflow, mapplet?

0 Answers  

---

Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks

3 Answers  

---

what are the different forms of normalization?

2 Answers  

---

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

2 Answers   CTS,

---

What are the different etl testing categories as per their function?

0 Answers  

---

What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

0 Answers  

---

what make u disappointmnets in u r career

0 Answers   Infosys,

---

Which transformation we use to convert 'NA' to 'Not Available'

0 Answers  

---

What are materialized views & where do we use them?

0 Answers  

---

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

0 Answers  

---

Explain and compare etl & manual development?

0 Answers  

---