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
- 16263 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
How to generate or load values in to the target table based on a column value using informatica etl tool.
What are active transformations.
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
what is informatica metadata?
update strategy transformation in informatica
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain the scenario which compels informatica server to reject files?
How to elaborate tracing level?
How to extract the informatica rejected data?
What is meant by lookup transformation?
What are the different transaction levels available in transaction control transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
How many ways are there to do 'remove duplicate records in informatica'?
what is SDLC way of code development?
What are mapplets?
