I had 10,000 records r there i loded today 4000 records, i
need load to 4001 - 10,000 next day how is in Type 1 and
how is it on type 2?

Answer Posted / eswer

hi pappu...it is the correct question ly.He touchess about
SCD TYPE1 and SCD Type2 which plays an very importent role
in desining of tables

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What exactly do you know about the typical data analysis?

615


Mention what is the syntax for m_dump in abinitio?

980


Explain the methods to improve performance of a graph?

681


How data is processed and what are the fundamentals of this approach?

651


How scientific data processing is different from commercial data processing?

639






Have you ever encountered an error called “depth not equal”?

661


What are the kinds of layouts does ab initio supports?

588


What are the functions of the replicate and dedup component?

639


What is a look-up?

674


What do you know about abinitio?

773


What is a deadlock and how it occurs?

679


What would be the next step after collecting the data?

744


Mention what dedup-component and replicate component does?

627


explain the environment varaibles with example?

637


Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?

575