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
Is it possible to define a single node as a Gateway node as well as worker node?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Explain why we use partitioning the session in informatica?
can u give example for factless fact table
What is lookup change?
What can we do to improve the performance of informatica aggregator transformation?
What is powercenter on grid?
What is domain in terms of informatica?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How identifying bottlenecks in various components of informatica and resolving them?
What are the features of complex mapping?
What are the informatica performance improvement tips