Home » Developer & Programmer » Data Integration » Informatica
Informatica [message #147794] Mon, 21 November 2005 01:41 Go to next message
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?
Re: Informatica [message #147797 is a reply to message #147794] Mon, 21 November 2005 02:24 Go to previous messageGo to next message
Maaher
Messages: 7064
Registered: December 2001
Senior Member
Does this have anything to do with OWB (Oracle Warehouse Builder)?

MHE
Re: Informatica [message #147821 is a reply to message #147797] Mon, 21 November 2005 04:50 Go to previous messageGo to next message
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.
Re: Informatica [message #147829 is a reply to message #147794] Mon, 21 November 2005 05:24 Go to previous messageGo to next message
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.
Re: Informatica [message #486705 is a reply to message #147829] Sun, 19 December 2010 04:27 Go to previous message
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.
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:
  


Current Time: Sun Sep 19 11:24:23 CDT 2021