Home » Developer & Programmer » Warehouse Builder » Regarding Informatica
Regarding Informatica [message #545725] Thu, 01 March 2012 23:24 Go to next message
Sabarish37
Messages: 5
Registered: February 2012
Location: Chennai
Junior Member
Hi,

In Informatica how to compare the attribute of previous record with the attribute of the current record.

Example:

From a flat file am getting the records, my reqiurement is to get the duplicate records and load it in one target and to get the distinct records and load it in another target. Please do help me on this....


Thanks & Regards,
Sabarish

Report message to a moderator

Re: Regarding Informatica [message #546045 is a reply to message #545725] Sun, 04 March 2012 23:28 Go to previous messageGo to next message
knw15pwr
Messages: 121
Registered: March 2010
Senior Member
You can use the Expression transformation for this.
Assign the incoming value to a variable and then you can check in another variable(or output port) whether the previous variable value is equal to the current incoming value.

Report message to a moderator

Re: Regarding Informatica [message #546823 is a reply to message #545725] Fri, 09 March 2012 02:39 Go to previous message
pratik4891
Messages: 28
Registered: February 2011
Junior Member
Sabarish37,

You can use the below logic
Your mapping flow should be like this

SRC -> SQ ->AGGR -> ROUTER -> TARGET1 and TARGET2

In the aggr put all the columns from source
add a new column ANT
IN AGGR group by the key column
IN the router create two groups
1)CNT =1 TARGET 1 (non duplicate records )
2)CNT >1 TARGET 2 (duplicate records )

Is this answer your question ?

Report message to a moderator

Previous Topic: Oracle IOP and OLAP option in Database
Next Topic: OWB from Unix
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 22 05:59:27 CDT 2013

Total time taken to generate the page: 0.23211 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.