Interested to Buy Any Domain ? << Click Here >> for more details...
how many ways can we implement SCD2?
- 4 Answers
- 15677 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sbvp
1.FLAG
2.versioning
3.date range
there is three types to implement scd2.
| Is This Answer Correct ? | 16 Yes | 1 No |
Answer / pune.rohitsharma
my ans is
1)date range
2)key
3)flag
here i have one thing to say
what about with pk key and with out pk will it come into
picture when we are talking about diff ways of implementing
SCD type 2
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / kumar raja kotakonda
1) FULL HISTORY
2) DATE RANGE
3) VERSINING
4) FLAGING
| Is This Answer Correct ? | 2 Yes | 0 No |
In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?
Why update strategy and union transformations are active?
what is diffrence b/w joner and union transfermation
Describe the impact of several join conditions and join order in a joiner transformation?
hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?
Is there any way to read the ms excel datas directly into informatica?
Explain the shared cache and re-cache?
How do you implement unconn. Stored proc. In a mapping?
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 powercenter on grid?
How to extract sap data using informatica?
How to import oracle sequence into Informatica?
Teradata 
