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
- 15823 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
Sequence generator, when you move from develoment to production how will you reset
What is expression transformation?
How can we use batches?
What is workflow? What are the components of workflow manager?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Is stop and abort are same in informatica?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What are the popular informatica products?
Where can we find the throughput option in informatica?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How to improve the performance of a session using sorter transformation?
What is the difference between stop and abort in informatica
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is a connected transformation?
Tell me about Propagate functions in informatica
