Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

hi all, i have 1 flat file having 10 rows. like:-

id name amt
100 a 100
200 b 200
100 n 300
400 p 3000
100 a 100
600 x 6000

Now i want to load half of this data into one flat file and
remaining in other flat file.like :-

flat file 1

id name amt
100 a 100
200 b 200
100 n 300
----------------------
----------------------
flat file 2

id name amt
400 p 3000
100 a 100
600 x 6000

Plz reply me ASAP.

Answer Posted / honey

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.

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are batches?

1103


In warehouses how many schemas are there?

1074


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

2010


What is the benefit of partitioning a session?

1183


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1584


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1628


Can you use flat files in Mapplets.

2654


can any one give some examples for pre sql and post sql(Except dropping and creating index).

4112


Explain pmcmd command usage in informatica

1139


What is source qualifier transformation in informatica?

1014


What is intricate mapping?

1211


what is the complex transformation you used in informatica

2589


What is rank transformation?

991


define galaxy repository in informatica

2232


What is the function of look up transformation?

1125