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 / indra

NOT GOT APPROPRIATE RESULT BY GOING THROUGH THE SOLUTION
GIVEN BY Shashank....

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2353


What is domain in terms of informatica?

1056


what is the -ve test case in your project.

2458


What is the difference between informatics 7x and 8x and what is latest version?

1137


What are the settings that you use to configure the joiner transformation?

1102


What is a code page?

1219


Separate from an archive server and a powerhouse?

1007


Do you find any difficulty while working with flat files as source and target?

1146


Design time, run time. If you don't create parameter what will happen

1892


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)

1677


where to store informatica rejected data?

1139


What can we do to improve the performance of informatica aggregator transformation?

1142


Explain the different lookup methods used in informatica?

1096


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9898


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6580