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
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: 131
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.
Re: Regarding Informatica [message #546823 is a reply to message #545725] Fri, 09 March 2012 02:39 Go to previous message
pratik4891
Messages: 53
Registered: February 2011
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 ?
Previous Topic: Oracle IOP and OLAP option in Database
Next Topic: OWB from Unix
Goto Forum:
  


Current Time: Mon Nov 24 08:23:45 CST 2014

Total time taken to generate the page: 1.36014 seconds