In Source Qualifier and in Target I have 1,2,3 row and I want to insert 4,5 records in source and I want them in target also? What is the procedure to load them?

Questions by sravanmca2k5

Showing Answers 1 - 6 of 6 Answers

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.

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions