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

how to create user defined function (udf) in informatica

0 Answers   Informatica,

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

0 Answers  

What is data caches/ index caches?

0 Answers  

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,

what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

0 Answers   CTS,

Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers   TCS,

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.

5 Answers   Amdocs,

Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

0 Answers  

How to go to the older version for a mapping?

0 Answers  

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,

For more Informatica Interview Questions Click Here
Categories