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
- 0 Answers
- 465 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How do you improve the performance of a graph?
what is the difference between the .dbc and .cfg extensions and give any clear information ?
Explain the methods to improve the performance of a graph?
In MFS i developer developed 2-way, but supporters r supporting 4-way on same records how is possible?
Explain what does dependency analysis mean in abinitio?
Can you explain the performance and scalability of co> operating system?
What is a deadlock and how it occurs?
Runtime behavior of Normalize and Reformat
what is the use of stdenv in abinitio and what the main concept belongs to is?what is env?
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?
What do you mean by a transaction file and how it is different from that of a sort file?
explain checkin and checkout?
Teradata 
