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

Define informatica repository?

2 Answers   Wipro,

Explain in detail about scd type 1 through mapping.

0 Answers  

whats the option in informatica 7 version is outdated in informatica 8 version onwards.

1 Answers   iGate,

In which scenario did you used pushdown optimization?

1 Answers  

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

2 Answers   IBM,

What are the Differences between static cache and dynamic cache?

1 Answers  

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers   Zensar,

What are pre and post-session shell commands?

0 Answers  

can we use self join in informaitca?

3 Answers   IBM,

i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/

5 Answers   L&T,

what is casual dimension?

6 Answers   IBM,

What is the meaning of decode in informatica?

0 Answers  

For more Informatica Interview Questions Click Here
Categories