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
- 16850 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
have u done any performance tuning? how u ll do?
What do you mean by worklet?
What are session parameters ? How do you set them?
Explain joiner transformation in informatica
How many dimensions are there in informatica?
What is DR strategy for Informatica project?
What is the format of informatica objects in a repository?
What is a filter transformation?
What is the procedure for creating independent data marts from informatica 7.1?
How to update a particular record in target with out running whole workflow?
Explain 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?
What is a dimensional model?
What does reusable transformation mean?
What are the designer tools for creating transformations?
what is size of u r database?
