Update strategy transformation is an active
transformation.How it changes the number of records that
pass through it? Please explain....
Answer Posted / kondareddy
for example take one condition in update strategy
source we have 20 records. in that records we have 4 records has less then 500 salary
in update strategy condition is
iif(sal<500,3,sal) based on that condition only 15 records stored into target. so it will be effected on rows. becoz in update strategy 3 indicates rejected records....
so it is active....
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What can we do to improve the performance of informatica aggregator transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How to use pmcmd utility command?
what is Active lock explain
What is a snowflake schema?
difference between repository database and repository service?
What does refresh system mean, and what are its distinctive choice?
what is the size of your data warehousing?
How do we call shell scripts from informatica?
What is the difference between a connected look up and unconnected lookup?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How to elaborate powercenter integration service?
What is an Integration service in Informatica?
tell me about your project functionality
What are active transformations.