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
What would be the next step after collecting the data?
Define ramp limit in ab initio?
how will i can implemate Insert,Update,delete in abinitio? how will u view MFS in unix?what is diff/btween conditional dml& conditional component?
What is the role of co-operating system in abinitio?
) Layout? What is the Dataset & Program Component Layout
Describe the grant/revoke ddl facility and how it is implemented?
How to load the data from an excel sheet to input file in a graph?
What is the syntax for m_dump in abinitio?
Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?
How many parallelisms are in Abinitio?
What are the key elements of a data processing system?
Why do you think data processing is important?