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.
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
What are the main issues while working with flat files as source and as targets ?
How to implement security measures using repository manager?
Define Pmrep command?
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?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Sequence generator, when you move from develoment to production how will you reset
What are the new features of informatica 9.x in developer level?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Can anyone tell me the new features in Informatica 9 Version?
What are the settings that you use to configure the joiner transformation?
What are data-driven sessions?
When do you use sql override in a lookup transformation?
Explain the use of aggregator cache file?
Why union transformation is an active transformation?