What is the difference between reformat and redefine format?




Answers were Sorted based on User's Feedback



What is the difference between reformat and redefine format?..

Answer / sohanvarma

Reformat->Changes the record format of your data by
dropping fields or by using DML expressions to add fields,
combine fields, or modify the data.


Redefine Format->Copies data records from its input to its
output without changing the values. Use Redefine Format to
change a record format or rename fields.

Is This Answer Correct ?    19 Yes 1 No

What is the difference between reformat and redefine format?..

Answer / quesanswer

This was the answer i gave........
reformat performs the deriving new data by adding fields
dropping fields redefine format using for rename fields
The difference between Reformat and Redefine Format is that
Reformat can actually change the bytes in the data while
Redefine Format simply changes the record format on the data
as it flows through, leaving the data unchanged.

but then i was asked that renaming the feild and creating it
into a single record can be done bby reformat as well.then
waht is the use of redefine.

Is This Answer Correct ?    16 Yes 1 No

What is the difference between reformat and redefine format?..

Answer / 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 ?    0 Yes 0 No




What is the difference between reformat and redefine format?..

Answer / jak

in define format we cant change the dml.
it is used in merge ,concate

Is This Answer Correct ?    1 Yes 12 No

Post New Answer



More Ab Initio Interview Questions

what i the difference between the flows of 3 paralellisms

1 Answers  


Graph was failed how it is achived ? send answer with phone number? i want speak with directly who is intrest on abinitio?

1 Answers   HCL,


How can you achieve scan using reformat ?

2 Answers  


How Does MAXCORE works?

4 Answers   CTS,


How can you view the data in the Multifile

4 Answers   IBM,






name the air commands in ab initio?

2 Answers   Syntel, IBM,


how can you convert 3 way to 7way partitioning in abinitio?

4 Answers  


Which component breaks the pipe line parallelism in graph?

3 Answers   Wells Fargo,


What are the prioritized Rules in as Transform function

1 Answers  


what is difference between chk point n phase.Say im loading a file (containig 1 lakh records) and my graph fails after loading 50,000th record.What is the advantage of using check point in this case. Will i be able to start from 51000th record.

1 Answers   IBM,


from a graph how to select only second record always in scan?

3 Answers   IBM,


What is the difference between In-Memory Sort and Inputs must be sorted?

3 Answers  






Categories