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
- 19807 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 |
Explain what is the architecture of abinitio?
What kind of layouts does abinitio support?
what is environment variables and parameters?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?
What is air-project parameter ? How to use in abinitio graph?
3 Answers IBM, TCL, Tech Mahindra,
Why creation of temporary files depends on the value of MAX CORE ? How to use in abinitio graph? 10. What is the diff between abinitiorc and .abinitiorc files ? How to use in abinitio graph? 11. What is the use of allocate()? How to use in abinitio graph? 12. What is use of branch in EME ? 13. How you can break a lock in EME ? How can you lock a file so that only no one other than EME admin can break it ? How to use in abinitio graph? 14. When you should be using ablocal() ? How you can use ablocal_expr? How to use in abinitio graph? 15. Why you should not keep the layout as 'default' for input table component ? How to use in abinitio graph? 16. What is dynamic lookup ? How to use in abinitio graph? 17. What is dependent parameter ? How to use in abinitio graph? 18. What is BRE ? (Business Rule Environment - This is a recent addition in abinitio package) How to use in abinitio graph? 19.What is output index ? How to use in abinitio graph? 20. How you can track the records those are not getting selected from ‘select’ in reformat component ? How to use in abinitio graph? 21. Can we have more than one launcher process for a particular graph ? How about agent ? How to use in abinitio graph? 22. There are lot of new fuctions added in 2.15 , you can ask about them ? How to use in abinitio graph? 23. How can you run multiple instances of a graph in parallel? How to use
what is the difference between ab_work_dir and .work
What is the role of co-operating system in abinitio?
how does deadlock occur?
Have you worked with packages?
why Skew should always be 0 ? How to use in abinitio graph?
What is meant by Co > Operating system and why it is special for Ab-initio ?
Teradata 
