why do we go for update strategy tr in SCD rather using the
session properties?
- 3 Answers
- 15665 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
How to delete duplicate records in a flat file source?
TELL ME ABOUT WORK FLOW SCHEDULING?
permutations of mapplet
What are Dimensions and various types of Dimensions?
Tell me one complex query in oracle ?
What is confirmed dimension?
Which means the first record should come as last record and last record should come as first record and load into the target file?
i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?
What is the sql query overwrite in source qualifier in informatica
which quality process u can approach in ur project
what is SDLC way of code development?
How we can use union transformation?
Teradata 
