Interested to Buy Any Domain ? << Click Here >> for more details...
Update strategy transformation is an active
transformation.How it changes the number of records that
pass through it? Please explain....
- 2 Answers
- 21100 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
How to load the data from a flat file into the target where the source flat file name changes daily?
Describe two levels in which update strategy transformation sets?
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
What is update strategy transform?
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks
How can you run a session without using server manager?
Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you
what are types of dimentions?
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
What is persistent lookup cache?
If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
Teradata 
