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 / 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 |
Post New Answer View All Answers
How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa
What do you understand by overflow errors?
How to add default rules in the transformer?
What is ab initio enterprise meta>environment (eme)?
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
What is a partition and what are the different types of partition components in abinitio?
What is a rollup component?
What will be the skew for, input file->partition by key-> partition by round robin->output file
What are the types of data processing you are familiar with?
Give one reason when you need to consider multiple data processing?
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?
When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?
I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?
What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
What is is a data flow graph?