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
- 16389 Views
- I also Faced
- E-Mail Answers
Answer Posted / srinivasarao dasari
Find the count of the records using `wc -l` Command and
pass this to mapping varaiable.Now you can route the data
by dividing 2.I hope this would be helpful to you.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Difference between Target-based loading and constraint-based loading?
Explain how to import oracle sequence into informatica?
Difference between Data and Index Caches?
What is workflow manager?
can you please explain me pre session and post session options?
Enlist the tasks for which source qualifier transformation is used.
What are multi-group transformations?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What is parallel processing in informatica?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Write the unconnected lookup syntax and how to return more than one column.
What are Dimensional table?
As union transformation gives UNION ALL output, how you will get the UNION output?
Can informatica load heterogeneous targets from heterogeneous sources?
Explain constraint based loading in informatica
