We have file having country_name customer_name.For exp
London Ram
Bangalore Rohit
London Shyam
Bangalore Abhinav
In output we need 2 files one file for london and second file for Bangalore.How to acheve this?

Answer Posted / ritika

Thanks Subramaniam....but I want the result as generic. In this you are assuming only two cities that is London and Bangalore but it can be any number of cities, today it is coming only london and Bangalore later it can come as Delhi, Chennai and Bangalore. In this way we have to create separate output file for each city.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how you can run a graph infinitely in ab initio?

670


How can you export a component’s internal parameters ?

1920


What do you understand by a cartesian join?

654


Explain what does dependency analysis mean in abinitio?

558


Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?

650






What is publickey and private key?what is the use of this two keys?

2339


What do you mean by a transaction file?

667


Name the different type of processing based on the steps that you know about?

608


What is a rollup component?

625


Explain what is the architecture of abinitio?

662


what is the output when -1 is put in select_expr of FBE?

936


What does it mean by the term 'sort component'?

674


What are the reasons for which business can trust the approach of data processing?

615


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

459


Mention how can you connect eme to abinitio server?

852