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
lookup transformation with screenshots
4 yrs etl devloper roles and responsibilities?any body give solutions
Explain dynamic target flat file name generation in informatica
Explain the code page compatibility?
What are the different types of repositories created using informatica?
How can one identify whether mapping is correct or not without connecting session?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is a passive transformation?
Define enterprise data warehousing?
What are the new features of informatica 9.x at the developer level?
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
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
difference between repository database and repository service?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?