![]() Master Outer Join – keeps all rows from the detail and matching rows from masterĭetail Outer Join – keeps all rows from the master and matching rows from detailįull Outer Join – keeps all rows from both master and detail Normal Join – keeps only matching rows based on the condition What are the different join types within a Joiner transformation and describe each one? We can set this with any type of conditional logic within the update strategy expression property. This information lets the Integration Service know how to treat each record passed to a target. The Update Strategy Transformation in Informatica helps us tag each record passed through it for insert, update, delete, or reject. What is an Update Strategy Transformation in Informatica? If all processes are not complete after this time out period, the session gets terminated. What is the difference between stopping and aborting a workflow session task?Ī stop command tells the Integration Service to stop reading session data, but will continue writing and committing data to targets.Ī abort command works exactly like the stop command, however it will tell the Integration to stop processing and committing data to targets after 60 seconds. If the Integration Service cannot push all transformation logic to the database, it performs both source-side and target-side pushdown optimization. Full pushdown optimization – The Integration Service attempts to push all transformation logic to the target database. Target-side pushdown optimization – The Integration Service pushes as much transformation logic as possible to the target database.ģ. Source-side pushdown optimization – The Integration Service pushes as much transformation logic as possible to the source database.Ģ. What are the different types of pushdown optimization that can be configured?ġ. In the earlier versions of Informatica, lookup used to be a passive transformation but from Informatica 9x, Lookup transformation can be configured as as “Active” transformation which can output multiple rows based on the configuration. Is lookup an active or passive transformation? The number of Input Rows will vary as compared with the Output rows and hence it is an Active transformation. ![]() The Integration Service discards duplicate rows compared during the sort operation. When the Sorter transformation is configured to treat output rows as distinct, it assigns all ports as part of the sort key. This is because of selecting the “distinct” option in the sorter transformation property. How to return 2 columns from an unconnected lookup?Ĭoncatenate 2 columns and get combined value into return port Performance detail file (if configured).What are the different files that Informatica server creates? Scenario 2: when ever the input row count is much smaller as compared to the lookup row count…įor ex:- if you have 10K rows from source and the lookup table is having 10M rows, here it would make more sense to have a multiple hit to database against creating a lookup cache which take much time and resource expensive activity and un cached lookup would be faster than cached lookup ![]() Scenario 1: if the look up logic to be performed only on smaller number of selected rows In what scenarios un cached lookup transformation is preferred?
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |