Here's my problem.  To implement my incremental load logic, when pulling the data from the source I want to limit the rows based on the max load date in my transformation layer.  Source and transformation layer are two different servers.  DB2 - so no db links.  How can I accomplish this in Informatica?

Thanks in advance.

I am using timestamp logic to inplement the incremental load - problem is I want to base what I am pulling from the source (Sybase) on the last update date in the DW (db2).  Because of the multiple connections - I cant just do this simply in the source qualifier.

I figured it out though.  Here is what I did in case it helps anyone else in the future:  I created two separate mappings and execute them consecutively in a workflow.  Session 1 gets me the max update date from the DW, which I set the mapping variable to.  In the post session, I set a workflow variable to this variable.  The second session does the pull from staging.  This mapping also had a mapping variable - which I sent in the pre session to the value in the workflow variable.  Then I use this variable in the source qualifier to limit the records based on the last update date.  It seems like you should be able to do this in a single mapping with 2 pipelines - but the variables werent holding their values as expected - so I split them up.