how many ways can we implement SCD2?
- 4 Answers
- 16083 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 |
How can you access the remote source into your session?
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
If informatica has its scheduler why using third party scheduler?
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com
How to load only the first and last record of a flat file into the target?
How do you change a non-reusable transformation to reusable transformation?
If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
Define the various join types of joiner transformation?
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
How is union transformation utilized?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Teradata 
