why do we go for update strategy tr in SCD rather using the
session properties?
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 |
tell me 5 session failure in real time how can you solve that in your project?
What are the active and passive transforamtions?
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance
What are the measure objects?
Explain the aggregator transformation?
How do you change a non-reusable transformation to reusable transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
can we generate reports in informatica ? How?
What is a test load?