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
- 19612 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 the output when -1 is put in select_expr of FBE?
What is data mapping and data modelling?
What are the components new in 2.14 compared to 1.8 and State the usage of the components?
Can you explain the performance and scalability of co> operating system?
One file contains header,body,trailer records and header in a single row as well as trailer too.How to segregate these header,trailer and body records and once it gets segregated,i want to make the body data in reverse i.e if i have 10 body records,the 10th record should be the first record,9th record should be the second line,etc..
I have a DML in my local system the location is E:/u/home/khaleel/dml how to convert this path to $DML?
Explain what is the architecture of abinitio?
What is $mpjret? Where it is used in ab-initio?
Order of Evaluation of Parameters
Mention what are the different types of parallelism used in abinitio?
what is decoding & what is NVL?
Pdl with an example?
Teradata 
