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



Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output s..

Answer / 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

More Ab Initio Interview Questions

If m loading a file of 1 million records.and the graph fails after loading 10,000 records. In this case if we use rollback command then what will happen?

4 Answers   IBM,


What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?

0 Answers  


How can you find the 2nd Highest salary in a file department wise in abinitio?

9 Answers   IBM, TCS,


We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?

0 Answers  


How can you import XML repositories exported from different tools like ODI

0 Answers  


What is the difference between rollup and scan?

0 Answers  


Mention what is a partition and what are the different types of partition components in abinitio?

0 Answers  


Which Ab initio version has Hadoop connector ? and what is the latest GDE version available ?

1 Answers   Infosys, TCS,


Difference between output_index and output_indexes in reformat

0 Answers  


How can you increase the number of ports of your output flow? What is the limit? Can i have 20 out ports?

2 Answers   IBM,


How can you view the data in the Multifile

4 Answers   IBM,


How scientific data processing is different from commercial data processing?

0 Answers  


Categories