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?
Answers were Sorted based on User's Feedback
Answer / ss
simply take a reformat component and then put
next_in_sequence()> 4000 in select parameter.
Is This Answer Correct ? | 21 Yes | 2 No |
Answer / pappu
First, The interviewer is !! He shud ask question which is relevant to project and scenario, which he doesn't have any idea.
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / mahendra patnaik
Take 10,000 records as source file and take output table as
another source and then Join both the source,select input
must be sorted parameter option in the Join component,If
any matching records found then put that into a thrash,
take all unmatched records and inert into the target table.
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / amansharma3737@gmail.com
Hii
Question is correct.
In case of type one.. Record will be there in database but history won't be present.
In case of type two.. record and history both will be available( we can use effective date to get the history )
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
What is dependent parameter ?
I installed AbInito in my PC.In components there is no "select" component.How can i get that component?and How we can create user defined components?
what is the difference between .dbc and .cfg file?
Do you think effective communication is necessary for data processing? What is your strength in terms of same?
What is MAX CORE of a component?
what is the syntax of m_dump command?
hi, am put into Ab initio now. I need some material for to learn it!! i have to give a test also.. can anyone help me provide material please....
What is publickey and private key?what is the use of this two keys?
If m loading a file of 1 million records.and the graph fails after loading 10,000 records. In this case if we use rollback command then what will happen?
Describe how you would monitor and control database physical file size and growth?
What does edp stand for?
what is difference between fuse and join? Explain in detail? In which scenario we will use them?