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.
946Input - 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 1502how 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
2065How 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
1945
What is broadcasting and replicate?
What is the difference between look-up file and look-up, with a relevant example?
How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?
What are differences between different versions of co-op?
How can you force the optimizer to use a particular index?
What is the importance of eme in abinitio?
Have you used rollup component? Describe how.
What do you mean by a transaction file?
What are the reasons for which business can trust the approach of data processing?
What are the co> operating system’s assorted library of integrated components?
Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com
What are the factors on which storage of data depends?
What is the purpose of having stored procedures in a database?
What is the difference between check point and phase?
Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?