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
- 16244 Views
- I also Faced
- E-Mail Answers
Answer Posted / sajjan
solution1:- use rank transformation, divide into two
quartiles and pass them to different targets
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
list out all the transformations which use cache?
What is option by which we can run all the sessions in a batch simultaneously?
What is meant by lookup transformation? Explain the types of lookup transformation?
How does a sorter cache works?
How to load a Dimension ? and how to load a fact table?
EXL informatica Questions
Is it possible to revert a global repository to local one and why?
What is a code page?
Explain the different dimensions.
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Partition, what happens if the specified key range is shorter and longer
What are the guidelines to be followed while using union transformation?
What is lookup transformation?
What is workflow manager?
