in this logic , frist take one sequene genrator 
transformation ,pass next value to expression 
transformation  and also pass id,name,and amt.
in this transformation and also  create one output port
(temp).it is decimat type and write codition like 
(iif(NEXTVAL %2=0,0,1)) , after take one router 
transformation ,pass these ports (id,name,amt and  
temp) .then create two group ,one is temp=0 and another one 
is temp=1.after pass first group to one flat file ,second 
group to second flat file.

when u apply the procedure given by Mr.Ramesh u will get 
alternative records to be stored in the two flatfiles.
Is this what u wanted.

solution1:- use rank transformation, divide into two 
quartiles and pass them to different targets

Thanks to all,

But i want to store first half data in 1 table and another 
half in another table. and with procedure i m getting 
alternative data.

Find the count of the records using `wc -l` Command and 
pass this to mapping varaiable.Now you can route the data 
by dividing 2.I hope this would be helpful to you.

Hi,

In the source file if the row count is odd number,then how 
can we check the condition to divide the ff into two halves?

If it is even,we can divide the ff into two halves as per 
the above solutions.

Please give me reply how to implent that

Thanks in Advance

send the flat file data into an expression transformation 
and create a new pory say xyz and connect nextval mport on 
seq_gen to this. then connect expression to router take two 
groups. using the nem port created write conditions. 
newport<5 in first group ice versa. i believe this would 
work

From source to expression connect ID, Name and Amt.
Add one sequence generator and connect to expression
now expression TF is like

expression
----------
ID
Name
Amt
Number

pass number port to aggregator TF to get the max value in 
number and pass ID,Name, amt and number from exression to 
router and max value from aggregator to router
now router is having ports
Id
Name
Amt
Number
Max

now route the rows on the basis of
number < max/2 (output group 1)
number > max/2 (output group 2)