Incremental Process?

[cwkinney]

I have a mapping that has two sources and one target.
Source 1 brings over all Associate Non-Salesperson Data with maximum Effective Date (so one row - newest row - per person).
Source 2 brings over all Associate Salesperson Data with history (changes in Dept, Manager, pay, etc).
The initial load works fine and all of the rows are populated into the target correctly.

I am now faced with trying to bring over all UPDATES (replacing a row with new information) and ADDS (inserting new non-salesperson info) from Source 1...
AND
INSERT (inserting row of existing salespersons while keeping all history rows) and ADDS (inserting new salesperson info) from Source 2.

I am assuming that this will be done with at least one lookup but I am not 100% sure if that is correct or, if it is, how to do it...

Could someone please give me some help or point me in the right direction?

Thank You

 

[walkerci]

cwkinney,

Take a look at the Update Strategy transformation.
You can use Constants to control the UPSERT activity.

DD_DELETE
DD_INSERT
DD_UPDATE

There is even a DD_REJECT to send rows to the reject file.

You also need to set your Target Options to Data Driven in Informatica Server Manager session wizard.

The Informatica Designer help screens provide very useful details on this functionality.

Good luck!

Charles

 

[blom0344]

Additionally take a look at the principle of slowly changing dimension tables. Perhaps these will have something to offer as well////////

T. Blom
Information analyst
tbl@shimano-eu.com