how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio
- 1 Answers
- 2243 Views
- I also Faced
- E-Mail Answers
Answer / Kavita Tiwari
In Ab Initio, you can use DataFlow Manager (DFM) to insert or update records in a CSV file. Here's an example process:
1. Load your input CSV file into a variable using the 'Read Text File' step.
2. Sort the data based on a unique identifier column (such as primary key) using the 'Sort' step.
3. Use the 'Merge' step to compare the sorted data with an output file or another variable containing the desired records.
4. Implement conditional statements within the merge process to decide whether to insert new records or update existing ones based on the unique identifier.
| Is This Answer Correct ? | 0 Yes | 0 No |
Why might the optimizer use a table scan when an index is available?
what is difference between chk point n phase.Say im loading a file (containig 1 lakh records) and my graph fails after loading 50,000th record.What is the advantage of using check point in this case. Will i be able to start from 51000th record.
What is the diff between abinitiorc and .abinitiorc files ?
What is use of creating a save files? How to use in abinitio graph?
1 Answers Cognizant, IBM, Intellego, TCL,
Have you worked with packages?
What is the best way of creating huge test feeds ? How to use in abinitio graph?
Difference between Force_error & Force_abort?
What is data mapping and data modelling?
What are the kinds of layouts does ab initio supports?
What is the ab initio business rules environment (bre)?
Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?
What are the differences between informatica and abinitio?
Teradata 
