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.
515Input - 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
461how 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
1288How 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
1479
Do you think effective communication is necessary for data processing? What is your strength in terms of same?
What are the benefits of data analyzing?
What happens when we provide null key to sort, merge and pbks in Abinitio ?
Explain the difference between the truncate and delete commands?
What do you mean by the term data warehousing? Is it different from data mining?
What is brodcasting and replicate?
What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?
What are the kinds of layouts does ab initio supports?
What is sandbox?
How do you truncate a table?
What are the types of data processing you are familiar with?
Mention what is abinitio?
What is the difference between check point and phase?
State the relation between EME, GDE and Co-operating system?
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