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



We have file having country_name customer_name.For exp London Ram Bangalore Rohit London Shyam B..

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

We have file having country_name customer_name.For exp London Ram Bangalore Rohit London Shyam B..

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

We have file having country_name customer_name.For exp London Ram Bangalore Rohit London Shyam B..

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

We have file having country_name customer_name.For exp London Ram Bangalore Rohit London Shyam B..

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

Post New Answer

More Ab Initio Interview Questions

Why might you create a stored procedure with the with recompile option?

0 Answers  


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

0 Answers  


Describe the effect of the "checkpoint" t-sql statement?

1 Answers  


how can you convert 3 way to 7way partitioning in abinitio?

4 Answers  


Suppose you find the term validation mentioned with a set of data, what does that simply represent?

0 Answers  






How to implement the funtionality in the custom component to use in the graph?

1 Answers  


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?

0 Answers  


What are the different types of partition components in abinitio?

0 Answers  


What is the diff between abinitiorc and .abinitiorc files ?

1 Answers   IBM, Infosys, TCL,


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

5 Answers   CTS,


What are the benefits of data processing according to you?

0 Answers  


What are the steps to create a repository in ab initio?

0 Answers  


Categories