Update strategy transformation is an active
transformation.How it changes the number of records that
pass through it? Please explain....
Answer Posted / jaimeen shah
You can configure the Update Strategy transformation to
either pass rejected rows to the next
transformation or drop them based on the update strategy
expression. By default, the PowerCenter Server forwards
rejected rows to the next transformation. The PowerCenter
Server flags the rows for reject and writes them to
the session reject file. If you do not select Forward
Rejected Rows, the PowerCenter Server
drops rejected rows and writes them to the session log file.
| Is This Answer Correct ? | 18 Yes | 2 No |
Post New Answer View All Answers
What is a pre-defined event and user-defined event?
what is Active lock explain
What is workflow? What are the components of the workflow manager?
Define Pmrep command?
How big was your fact table
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is primary and backup node?
What are some examples of informatica etl programs?
How do you update the records with or without using update strategy?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Define mapping and session?
What is an unconnected transformation?
What are the advantages of informatica?
How do you migrate data from one environment to another?
Enlist the tasks for which source qualifier transformation is used.