how many ways can we implement SCD2?
- 4 Answers
- 14827 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 |
What are the types of caches in lookup?
What are connected or unconnected transformations?
What does “tail –f” command do and what is its use as an Informatica admin.
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is the benefit of partitioning a session?
Explain the shared cache and re-cache?
What is checksum termnology in informatica? Where do you use it ?
3 Answers Chase, Cognizant, Deloitte,
What is update strategy transform?
if the session fails after 100 records agian we have to starts the session or we go for recovery session
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Teradata 
