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
No Answer is Posted For this Question
Be the First to Post Answer
How to move or copy the project parameter or project object to my sandbox?
What is the best way of creating huge test feeds ? How to use in abinitio graph?
Difference between informatica vs ab initio?
Explain batch processing in ab initio?
List out some of the air commands used in abintio?
What are the operations that support avoiding duplicate record?
What is a data processing cycle and what is its significance?
) How can you count the total no .of records in the specified partition in the Multifile?
What is the difference between rollup and scan?
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
Explain the difference between the truncate and delete commands?
how many types of project we can create in Abinitio? I mean public,private.......etc?