Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What exactly do you understand with the term data processing and businesses can trust this approach?

1164


What do you know about abinitio?

1314


Runtime behavior of Normalize and Reformat

2762


What are the co> operating system’s assorted library of integrated components?

1168


Explain the methods to improve performance of a graph?

1155


What are the factors on which storage of data depends?

1207


What is $mpjret?

1206


How can we increase the loading performance of oracle table in AbInitio?

1215


Explain what is de-partition in abinitio?

1408


How can a graph be run infinitely?

1176


What do you understand by a cartesian join?

1165


What are the benefits of data analyzing?

1237


What are the types of data processing you are familiar with?

1255


What are the functions of the replicate and dedup component?

1143


What happens when we provide null key to sort, merge and pbks in Abinitio ?

1747