OraFAQ Forum: Data Integration

Home » Developer & Programmer » Data Integration » Informatica

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Informatica [message #147794]

Mon, 21 November 2005 01:41

renukha
Messages: 7
Registered: November 2005
Location: Bangalore

Junior Member

Hi,
Can any one tell me how to eliminate the duplicate records without using dynamic look up?

Report message to a moderator

Re: Informatica [message #147797 is a reply to message #147794]

Mon, 21 November 2005 02:24

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Does this have anything to do with OWB (Oracle Warehouse Builder)?

MHE

Report message to a moderator

Re: Informatica [message #147821 is a reply to message #147797]

Mon, 21 November 2005 04:50

renukha
Messages: 7
Registered: November 2005
Location: Bangalore

Junior Member

hi Maheer,
Thanx for ur reply but i don't think so. We want that for only informatica.

Report message to a moderator

Re: Informatica [message #147829 is a reply to message #147794]

Mon, 21 November 2005 05:24

kiran
Messages: 503
Registered: July 2000

Senior Member

Quote:

Can any one tell me how to eliminate the duplicate records without using dynamic look up?

If you need to eliminate duplicate records , you cou either use "Aggregator" transformation by grouping all the columns in the table (or) else you could use "Sorter" transformation with "the select statment using distinct".

--Kiran.

Report message to a moderator

Re: Informatica [message #486705 is a reply to message #147829]

Sun, 19 December 2010 04:27

anilborru
Messages: 4
Registered: December 2010
Location: chennai

Junior Member

hi,
u can remove duplicate data thru source qualifier transformation Distinct option or sorter Transformation distinct option.

Report message to a moderator

Previous Topic:	Informatica notes
Next Topic:	RPE-01012: Cannot deploy to the target location because it is owned by a different runtime platform.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Oct 27 11:00:41 CDT 2025