What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
957Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output should be- Name|city |startyear|endyear Rahul |Mumbai|2010|2014 Rahul|kolkata|2014|2018 Rahul|Delhi|2018|9999
1 1518how 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
2077How 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
1960
What are the various types of layout supported by abinitio?
How can you force the optimizer to use a particular index?
What are the benefits of data analyzing?
What is de-partition in abinitio?
Mention what information does a .dbc file extension provides to connect to the database?
What information is provided by .dbc file extension for connecting to the database?
How co>operating system integrates with legacy codes?
What is the difference between formal and export parameter? Export at what secenario we are going to use?
Why is data processing considered beneficial?
can we perform checkin and checkout through sandbox?
Explain what is sort component in abinitio?
What is the syntax for m_dump in abinitio?
Mention some file extensions which are used in abinitio?
Why might the optimizer use a table scan when an index is available?
What is the difference between look-up file and look-up, with a relevant example?