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.

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

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)

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  

---

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,

---

what is incremental aggregation ,with example?

2 Answers  

---

What are the tasks that source qualifier performs?

1 Answers  

---

My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this

2 Answers  

---

In target table how to display the system time

1 Answers  

---

how to declare array in plsql?

1 Answers  

---

if i have a delimited file as source so how can we seperate this file into three diff targets?

2 Answers   TCS,

---

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

2 Answers  

---

Mention few advantages of router transformation over filter transformation.

0 Answers  

---

Without using Lookup & Sequence Generator, How to generate Sequence?

5 Answers   CTS,

---

why union is active transformation?

4 Answers   IBM,

---