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
How are the sources and targets definitions imported in informatica designer?
What does command task mean?
What are the types of caches in lookup? Explain them.
What is the Process to creating lookup transformation in informatica
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What are the types of lookup transformation?
What is the use of source qualifier?
Explain dynamic target flat file name generation in informatica
Enlist few areas or real-time situations where informatica is required.
Where are the source flat files kept before running the session?
What do you mean by blocking transformation?
In warehouses how many schemas are there?
What is the function of look up transformation?