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
How can you export a component’s internal parameters ?
How to create repository in abinitio for stand alone system(local nt)?
What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?
What do you mean by the term data warehousing? Is it different from data mining?
What is sandbox?
What is the core of co> operating system?
What are the Types of parallelism in detail?
Explain what is de-partition in abinitio?
What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
What happens when we provide null key to sort, merge and pbks in Abinitio ?
What would be the next step after collecting the data?
How scientific data processing is different from commercial data processing?
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 partitioning with key / hash and round robin?
Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com