1.

Explain data driven sessions.

Answer»

In Informatica Server, DATA-driven properties DETERMINE how the data should be TREATED when an Update Strategy Transformation is used for mapping. When using an Update Strategy Transformation, it MUST be specified whether you want DD_UPDATE (constant for updating record) or DD_INSERT (constant for inserting record) or DD_DELETE (constant for deleting record). It is possible for mapping to contain more than one Update Strategy Transformation. Thus, a Data-Driven property must be specified in a session property for that specific mapping in order for the session to execute successfully.  

Example: 

  • DD_UPDATE (Any time a record is marked as an update in the mapping, it will be updated in the target.)
  • DD_INSERT (Any time a record is marked as an insert in the mapping, it will be INSERTED in the target.)
  • DD_DELETE (Any time a record is marked as delete in the mapping, it will be deleted in the target.)


Discussion

No Comment Found

Related InterviewSolutions