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
What the difference between “look-up” file and “look is up” in abinitio?
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 is data mapping and data modelling?
How can you export a component’s internal parameters ?
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
Mention what information does a .dbc file extension provides to connect to the database?
Mention what are the different types of parallelism used in abinitio?
I installed AbInito in my PC.In components there is no "select" component.How can i get that component?and How we can create user defined components?
In abinitio, what types of parallelism are used?
Difference between informatica vs ab initio?
What are the features of ab initio?
How to add default rules in the transformer?
What is the difference between look-up file and look-up, with a relevant example?
Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?
explain checkin and checkout?