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
- 16402 Views
- I also Faced
- E-Mail Answers
Answer Posted / romi
Thanks to all,
But i want to store first half data in 1 table and another
half in another table. and with procedure i m getting
alternative data.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is joiner transformation in informatica?
What is aggregator transformation in informatica?
What is dimensional table? Explain the different dimensions.
What is mapping debugger?
How can we handle two sessions in informatica?
As union transformation gives UNION ALL output, how you will get the UNION output?
How to do unit testing in informatica? How to load data in informatica ?
r u done any partitions in ur project?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What are the issues you have faced in your project? How did you overcome those issues?
What is the difference between writing a joiner query in ANSI style and THETA style?
How can you define user defied event?
How can we update a record in the target table without using update strategy?
What are mapplets? How is it different from a Reusable Transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
