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
- 2240 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a rollup component? Explain about it.
What is rollup component?
can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................
How to add default rules in transformer?
Hi friends, what are the new features in abinito3.0?
