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.
- 10 Answers
- 16444 Views
- I also Faced
- E-Mail Answers
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
Enlist the differences between database and data warehouse.
What is domain in terms of informatica?
What is expression transformation?
How we can use union transformation?
What are the prerequisite tasks to achieve the session partition?
How to delete duplicate row using informatica?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is powercenter on grid?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is substr in informatica?
What are the static cache and dynamic cache in informatica?
How to call shell scripts from informatica?
How to configure mapping in informatica?
How to improve the performance of a session using sorter transformation?
What is persistent lookup cache?
