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

Post New Answer

More Ab Initio Interview Questions

What are the prioritized Rules in as Transform function

1 Answers  


What is meant by Co > Operating system and why it is special for Ab-initio ?

2 Answers  


What is a rollup component?

0 Answers  


Hi friends, i have input like below naresh 10,20 suresh 30,40 i want out put like naresh 10 naresh 20 suresh 30 suresh 40 please help me thank you

3 Answers  


What is the diff between abinitiorc and .abinitiorc files ?

1 Answers   TCL,






What is the core of co> operating system?

0 Answers  


i have 2 files. First file contains a,b,c,d as rows and second file contains 1,2,3,4 as rows. how do we make single a1b2c3d4 and 4 different rows a1, b2, c3,d4.

4 Answers   L&T,


What is standard environment ? How to use in abinitio graph?

1 Answers   IBM, TCL,


Describe the grant/revoke ddl facility and how it is implemented?

0 Answers  


. How can you get all the fields form a lookup files ? (Which function)

3 Answers   TCL,


What are the different types of parallelism used in abinitio?

0 Answers  


What are the different String functions used in Abinitio?

3 Answers   IBM,


Categories