Interested to Buy Any Domain ? << Click Here >> for more details...
why do we go for update strategy tr in SCD rather using the
session properties?
- 3 Answers
- 16890 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 |
There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,
what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?
Mention few advantages of router transformation over filter transformation.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
what is runtime variable?
how can u approach u r client
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
What is meta data and system catalog?
Is it possible to update the target table with PK?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
What are the tasks that source qualifier performs?
Teradata 
