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 do you understand by term role-playing dimension?
What is dynamic cache?
What is dimensional table? Explain the different dimensions.
Write the different tools in the workflow manager?
what is Active lock explain
what are the Methods For Creating Reusable Transformations?
How to start a workflow using pmcmd command?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
differences between service based and product based?
How do you convert single row from source into three rows into target?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What are the settings that you use to configure the joiner transformation?
Sequence generator, when you move from develoment to production how will you reset
How to differentiate between the active and passive transformations?
Define pmcmd command?