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

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

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

lookup transformation with screenshots

4050


4 yrs etl devloper roles and responsibilities?any body give solutions

2250


Explain dynamic target flat file name generation in informatica

1113


Explain the code page compatibility?

1123


What are the different types of repositories created using informatica?

1172


How can one identify whether mapping is correct or not without connecting session?

1498


in reporting we add some new objects,how we get the count of the newly added objects to the report

2254


What is a passive transformation?

1154


Define enterprise data warehousing?

1257


What are the new features of informatica 9.x at the developer level?

1110


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7505


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1128


difference between repository database and repository service?

1225


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

1648


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2190