Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 5 Answers
- 19814 Views
- CTS, IBM, I also Faced
- E-Mail Answers
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 local and formal parameter?
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?
Name the different type of processing based on the steps that you know about?
what is different daily and monthly develop the abinitio graphs?
What are the features of ab initio?
How will you use EME for view or publish metadata reports using EME?
Can any body give me the clear explanation about how to separate header,trailer and body records in Ab Initio?
What metadata importer can do in ab initio?
What are the different String functions used in Abinitio?
What is .abinitiorc and What it contain?
What do you mean by continuous graph? what is it significance?
Describe how you would monitor and control database physical file size and growth?
Teradata 
