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
- 1747 Views
- I also Faced
- E-Mail Answers
How do you improve the performance of a graph?
What are the fundamental blocks of co> operating system of ab initio?
How to run a graph infinitely?
What is the difference between dml expression and xfr expression?
What are the key elements of a data processing system?
What is the language used in Ab Initio ?
Can you explain the performance and scalability of co> operating system?
why Skew should always be 0 ? How to use in abinitio graph?
what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
What is a cursor? Within a cursor, how would you update fields on the row just fetched?
Why might the optimizer use a table scan when an index is available?
Why is data processing considered beneficial?
Teradata 
