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 Improve Performance of graphs in Ab initio?
What are the co> operating system’s assorted library of integrated components?
How can you increase the number of ports of your output flow? What is the limit? Can i have 20 out ports?
Explain what is sort component in abinitio?
What is the difference between rollup and scan?
How to run the graph without GDE?
Name the different type of processing based on the steps that you know about?
Can you explain the co>operating system’s processing model?
How can you import XML repositories exported from different tools like ODI
)what is wrapper script?where it is going to execute and why we go for wrapper?
How does PBK and Sort component and Join(in memory sort) work?I mean in the join component i have used In Memory Sort,so how will it work in terms of performence as compared with PBKand Sort Component?
I installed AbInito in my PC.In components there is no "select" component.How can i get that component?and How we can create user defined components?