Input -
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
Answer Posted / yash
We can use rollup to convert whole data in vector and later use vector data in normalize to assign last column.
rollup: use accumulation function on all columns
NORMALIZE:
length :: 3;
out::normalize(in,index)=
begin
out.name :: in.name[index];
out.city :: in.city[index];
out.startyear :: in.startyear[index];
out.endyear :: if(index==2) 9999 else in.startyear[index+1];
end;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What exactly do you understand with the term data processing and businesses can trust this approach?
What do you know about abinitio?
Runtime behavior of Normalize and Reformat
What are the co> operating system’s assorted library of integrated components?
Explain the methods to improve performance of a graph?
What are the factors on which storage of data depends?
What is $mpjret?
How can we increase the loading performance of oracle table in AbInitio?
Explain what is de-partition in abinitio?
How can a graph be run infinitely?
What do you understand by a cartesian join?
What are the benefits of data analyzing?
What are the types of data processing you are familiar with?
What are the functions of the replicate and dedup component?
What happens when we provide null key to sort, merge and pbks in Abinitio ?