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
- 16411 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
Describe expression transformation?
What do you understand by term role-playing dimension?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
how to load dimension table and fact table. plz tell me the steps.
What is an active transformation?
What are the data movement modes in informatica?
Tell me about MD5 functions in informatica
What is event and what are the tasks related to it?
What is a node in Informatica?
Differentiate between a repository server and a powerhouse?
Explain lookup transformation source types in informatica
How to do unit testing in informatica?
Enlist the advantages of informatica.
How big was your fact table
What is lookup transformation?
