Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between reformat and redefine format?
- 4 Answers
- 32618 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 ? | 21 Yes | 1 No |
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 ? | 17 Yes | 1 No |
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 ? | 3 Yes | 0 No |
Answer / jak
in define format we cant change the dml.
it is used in merge ,concate
| Is This Answer Correct ? | 1 Yes | 13 No |
Have you ever encountered an error called “depth not equal”?
What are the key elements of a data processing system?
What is the DynamicScriptGeneration and what is the Use?
How can you export a component’s internal parameters ?
Can someone tell me the behaviour of next_in_sequence() and innovation_number() in a multifile. Suppose I have records 1,1,1,2,2,3,4,4 in a 4ways mfs file. Data in each partition is: 0th : 1,1,1 1st : 2,2 3rd : 3 4th : 4,4 What will be the sequence of these records if I pass next_in_sequence() and innovation_number() ? Also how can I extract 3rd record from each of the 4 partitions of a 4way multifile through AbInitio? In unix we can use m_dump
What are the different types of parallelism in ab initio?
What are the prioritized Rules in as Transform function
How can you find the 2nd Highest salary in a file department wise in abinitio?
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
What a local lookup is?
Explain the difference between the truncate and delete commands?
Mention what information does a .dbc file extension provides to connect to the database?
Teradata 
