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
Explain how you can run a graph infinitely in ab initio?
How can you export a component’s internal parameters ?
What do you understand by a cartesian join?
Explain what does dependency analysis mean in abinitio?
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)?
What is publickey and private key?what is the use of this two keys?
What do you mean by a transaction file?
Name the different type of processing based on the steps that you know about?
What is a rollup component?
Explain what is the architecture of abinitio?
what is the output when -1 is put in select_expr of FBE?
What does it mean by the term 'sort component'?
What are the reasons for which business can trust the approach of data processing?
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
Mention how can you connect eme to abinitio server?