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
- 19969 Views
- CTS, IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What will be the skew for, input file->partition by key-> partition by round robin->output file
What is rollup component?
What is $mpjret?
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
What are the six data process products of ab initio (architecture of ab initio)?
How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC
What is data encoding?
What a local lookup is?
What are the different types of parallelism used in abinitio?
Why might the optimizer use a table scan when an index is available?
can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................
What does it mean by the term 'sort component'?
What is common among data validity and data integrity?
Mention some ways for improving performance of a graph?
Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?
