Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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....

Answers were Sorted based on User's Feedback



Update strategy transformation is an active transformation.How it changes the number of records th..

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

Update strategy transformation is an active transformation.How it changes the number of records th..

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

Post New Answer

More Informatica Interview Questions

How to load the data from a flat file into the target where the source flat file name changes daily?

0 Answers   Informatica,


Describe two levels in which update strategy transformation sets?

1 Answers  


Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,


What is update strategy transform?

0 Answers  


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.

3 Answers   Wipro,


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

4 Answers   Polaris,


How can you run a session without using server manager?

1 Answers  


Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you

6 Answers  


what are types of dimentions?

3 Answers  


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

21 Answers   Deloitte,


What is persistent lookup cache?

0 Answers  


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?

1 Answers   TCS,


Categories