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
- 16243 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
Write the advantages of partitioning a session?
What is meant by lookup transformation? Explain the types of lookup transformation?
Is it possible to revert a global repository to local one and why?
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
Can you generate sequence numbers without using the sequence generator transformation?
Is it possible to use a client with different version than that of its Informatica server?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How to load last n records of file into target table - informatica
Explain what are the different versions of informatica?
How do you load only null records into target?
What is an active transformation?
What do you mean by worklet?
What are some examples of informatica etl programs?
How to create or import flat file definition in to the warehouse designer?
What is the different lookup cache(s)?
