What is the difference between reformat and redefine format?
Answer Posted / avijit
Redefine format is best suitable in the following scenario.
Suppose we are reading the data from the input in a single line like a srting("
") and now that string i want to map into the different fields but i do not want to change the data then in the output dml of the redefine format i can specify the dml.
it will get the data mapped to the different fields.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio
explain checkin and checkout?
Describe the grant/revoke ddl facility and how it is implemented?
Describe what the SQL Server tempdb and tlog files are used for?
Explain what is sandbox?
Have you used the rollup component? Describe how?
What is data encoding?
When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?
What information is provided by .dbc file extension for connecting to the database?
How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on
How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?
What is the difference between dml expression and xfr expression?
How to create a repository in abinitio for stand-alone system(local nt)?
Mention what is rollup component?
Explain batch processing in ab initio?