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
Mention what is abinitio?
Describe how you would monitor and control database physical file size and growth?
How to run a graph infinitely?
What is m_dump?
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
One file contains header,body,trailer records and header in a single row as well as trailer too.How to segregate these header,trailer and body records and once it gets segregated,i want to make the body data in reverse i.e if i have 10 body records,the 10th record should be the first record,9th record should be the second line,etc..
Describe what the SQL Server tempdb and tlog files are used for?
Tell us about the architecture of abinitio.
Explain how you can run a graph infinitely in ab initio?
what is the difference between ab_work_dir and .work
Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?
How co>operating system integrates with legacy codes?