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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

why do we go for update strategy tr in SCD rather using the
session properties?

Question Posted / vaniser

Answers were Sorted based on User's Feedback



why do we go for update strategy tr in SCD rather using the session properties?..

Answer / shweta

Actually its important to use a update strategy
transofmration in the SCD's as SCDs maintain some historical
data specially type 2 dimensions. In this case we may need
to flag rows from the same target for different database
operations. Hence we have no choice but to use update
strategy as at session level this will not be possible.

Is This Answer Correct ?    14 Yes 3 No

why do we go for update strategy tr in SCD rather using the session properties?..

Answer / srinu

Hi,

Seession Properties like pre Souurce Rows
INSERT,UPDATE,REJECT,DELETE ,,
Using Session Properties We can do single flow only.

SCD aplicable for Insert,Update,,at a time using Update
Strategy trans only.
Using Update Trans we can creat SCD mapping easily.


Any Corrections Let me know
srinu.srinuvas@gmail.com

Is This Answer Correct ?    10 Yes 4 No

why do we go for update strategy tr in SCD rather using the session properties?..

Answer / akhil4

using update stratagey tr (or)session properties both are same.update stratagey using at mapping level,session properties using at wf level. (it's wrong correct me)

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More Informatica Interview Questions

Tell me about MD5 functions in informatica

0 Answers  

What is native users?

0 Answers  

What is resilience time?

0 Answers  

How to update records in Target, without using Update Strategy?

3 Answers  

Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)

1 Answers  

what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram

3 Answers  

why we use datawarehouse

0 Answers   HCL,

What are the data movement modes in informatica?

0 Answers   Informatica,

Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??

1 Answers   IBM,

What are the types of maping wizards that r to be provided in Informatica?

2 Answers  

What are the different options available for update strategy?

0 Answers  

Differentiate between mapping parameter and mapping variable?

1 Answers  

For more Informatica Interview Questions Click Here
Categories