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
- 15826 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
How to generate sequence numbers?
my source is junk data how will u remove that junk data by using unix please any one replay me
what is SDLC way of code development?
What is the function of look up transformation?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is a grid in Informatica?
Why union transformation is an active transformation?
Is it possible to revert a global repository to local one and why?
Explain incremental aggregation in informatica
What is the difference between Active and Passive transformation?
What is repository manager?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How to do unit testing in informatica?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
wat are deployement groups in informatica, how it will be used for developers
