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
What is sort component in abinitio?
What is a look-up?
How to move or copy the project parameter or project object to my sandbox?
What is data mapping and data modelling?
How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?
What is the purpose of having stored procedures in a database?
Have you worked with packages?
Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?
Code check-in and check-out commands in AbInitio
What do you know about abinitio?
When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?
What dedup-component and replicate component does?
What exactly do you know about the typical data analysis?
What is rollup component?
How would you find out whether a sql query is using the indices you expect?