What are Data driven Sessions?

The informatica server follows instructions coded into update strategy transformations with in the session mapping to determine how to flag records for insert,update,delete or reject. If you do not choose data driven optionn setting, the informatica server ignores all update strategy transformations in the mapping

Questions by satyaneerumalla   answers by satyaneerumalla

Showing Answers 1 - 1 of 1 Answers

fazal

  • Sep 7th, 2006
 

Once you load the data in your DW,you can update the new data with the following options in your session properties:-

1.update 2.insert2.delete and datadriven, and all these options are present in your session properties,now if you select  the datadriven option ,informatica takes the logic to update,delete or reject data from your designer update strategy transformation.it will look some thing like this

IIF( JOB = 'MANAGER', DD_DELETE, DD_INSERT ) this expression marks jobs with an ID of manager for deletion, and all other items for insertion.

Hope answer the question.

  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