Vamsi Krishna.K

• Oct 1st, 2006

 

If I'm not wrong, if you want to load records at source and target at a time, we consider source also as target. If you want to insert 4,5 records at target that is fine, how come you will load data at source it self. Source only having that 4,5 records. I

If you want to check in target before inserting 4,5, just use target table as lookup transformation.

if you have any primary key at target, you can use update stratergy with option update or insert instead of using lookup table.

If I'm wrong please let me know, i will try again.

Thanks.

kumar

• Oct 5th, 2006

 

   Hi

        Iam not sure please check it. first load the 4 and 5 records in source and then we are having an option in workflow manager, right click the session name and u will find an options , use second or third option it will do it.

or    We are having some settings in session properties

Actually iam not working in Informatica, iam not sure just check it Iam into businessobjects

PFD333

 Profile Answers by PFD333 

• Nov 6th, 2006

 

I guess u r talking abt dynamic addition of data....

For that first of all , the source in your current mapping should have been the target in some other mapping which u should be running before running the session of the current mapping. So then, run session S1, get the data (rows 4 and 5)on to ur desired database table (which is the target in 1st mapping and which is the source in ur current mapping)now run S2 which is the session of ur current mapping and get the desired rows on ur target table as well.

swati

• Nov 19th, 2006

 

Hi,I think it's very simple just insert the 4,5 rows at the database to the table do commit.Then run the workflow again.U'll get the answer that is all 1,2,3,4 & 5 recods.Thanksswati

sanjeev

• Aug 6th, 2007

 

I have one more idea. I think it is right.
In source qualifier we have a pre SQL and post SQL. using the pre SQL we can insert 4 and 5 records there.



Sanjeev

jayapraveen

 Profile Answers by jayapraveen 

• Oct 14th, 2010

 

i think this can be done by incremental aggregation at source side and target side