Answer / keyrun

Hi, There are many ways to delete the duplicates!

By Using the following Transformations you can delete the Duplicates:

Source Qualifier: Use SQ and check 'Distinct' property (If the Source is Relational)

Sorter: Use sorter and in Properties tab Check 'Distinct'(If the Source is Flat File)

Aggregator: Use Aggregator & Group by on the key port.

Answer / chandu

select * from from <table_name> where rowid not in(select
min(rowid) from <table_name> group by column(primary or
unique key column))

Answer / chandrasekar

First we can count the no of records using aggregator
Transformation with group by (port) for ex, in emp table
take empno. Second we can take the Filter condition like
count=1. Other records are rejected not loaded into the target.

Hope it will help little bit...

Answer / cmanojkumar

Hi,
Thanks for your answer.
I am sorry this question i need to post in oracle forum not
informatica.
Any way your answer is usefull for me.
Could you please tell me how can we delete with our rowid in
oracle ?

Answer / ravikumar2614

DELETE FROM EMP E1 WHERE ROWID<
(SELECT MAX(ROWID) FROM EMP E2 WHERE E1.ROWID=E2.ROWID)

IF I AM WRONG PLEASE CORRECT ME ON ravi.info2614@gmail.com

Answer / dilip ingole

Delete from emp where rowid not in(select min(rowid) from emp group by eid,ename)

in group by column you need mention all column in table

What are the differences between a connected lookup and unconnected lookup?

0 Answers  

my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,

How to Join Tables my Source is having 15 table target is one?

4 Answers   TCS,

HOW TO GET THE LATEST DATA IN SCD ?

4 Answers   TCS,

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 Answers  

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

0 Answers  

Why we need XMLs?

3 Answers   IBM,

What is DR strategy for Informatica project?

0 Answers  

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

1 Answers   TCS,

If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????

2 Answers  

Why touse stored procedure in ETL Application?

2 Answers