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
- 17099 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 |
what is persistant cache in which situation we will use persistantcache
how will you remove the duplicate records from flat file without using sorter?
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Please let me know how to make Data masking in informatica..
without dynamic lookup how to insert new rows and update existing rows?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
What is the scenario which compels informatica server to reject files?
How the dimensions will be loaded?
Why sorter is an active transformation?
What is the Hierarchy of DWH?
we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?
2 Answers Patni, Tech Mahindra,
Teradata 
