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
- 0 Answers
- 1485 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?
Difference between private project parameters ,public project parameters and common project parameters?
Describe which system or process elements you would review when trouble-shooting general server slows ?
Order of Evaluation of Parameters
What is sandbox?
What is regex (lookup)? When you should use it?
To which project that prefix will set is to private project or public project or both?how and where to set?
What are the different String functions used in Abinitio?
What do you mean by the term data warehousing? Is it different from data mining?
explain checkin and checkout?
what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
Difference between Force_error & Force_abort?
Teradata 
