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?
Answers were Sorted based on User's Feedback
Answer / subramanian
Set Count Parameter in Reformat to 2 to create 2 output ports.
Use Output_index parameter in Reformat Component to direct the record with city field having 'London' to one of the port .
Another condition checking city field for 'value 'Bangalore' and direct it to second out port.
count parameter set to 2.
if (field_1 == "London") 0
else
1
Is This Answer Correct ? | 20 Yes | 2 No |
Answer / keerthika
We can use Partition By expression to partition the data based on the Value in input data
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / devendra majhi
We can use "Write Multiple Files" component for this.
assign filename field with whatever expression you like and create file dynamically.
But select "oerwritte" option as false in that component
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / 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 |
Why might you create a stored procedure with the with recompile option?
Name the different type of processing based on the steps that you know about?
Describe the effect of the "checkpoint" t-sql statement?
how can you convert 3 way to 7way partitioning in abinitio?
Suppose you find the term validation mentioned with a set of data, what does that simply represent?
How to implement the funtionality in the custom component to use in the graph?
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 are the different types of partition components in abinitio?
What is the diff between abinitiorc and .abinitiorc files ?
Hi friends, I have 100 records in my input file, if i run first,the first 10 records are stored into the output and if i run second time next 10 records stored into the output file like that please let me know the answer Thanks, krishna
What are the benefits of data processing according to you?
What are the steps to create a repository in ab initio?