how many ways can we implement SCD2?
- 4 Answers
- 14381 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 basic requirements to join two sources in a source qualifier transformation using default join?
how to move the mappings from your local machine to claint place?
Enlist some properties of sessions.
What are the restrictions of union transformation?
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
Can anyone tell me the new features in Informatica 9 Version?
Write the unconnected lookup syntax?
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
What do think which one is the better joiner or look up?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer
Teradata 
