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
- 16390 Views
- I also Faced
- E-Mail Answers
Answer Posted / rashmi garg
From source to expression connect ID, Name and Amt.
Add one sequence generator and connect to expression
now expression TF is like
expression
----------
ID
Name
Amt
Number
pass number port to aggregator TF to get the max value in
number and pass ID,Name, amt and number from exression to
router and max value from aggregator to router
now router is having ports
Id
Name
Amt
Number
Max
now route the rows on the basis of
number < max/2 (output group 1)
number > max/2 (output group 2)
| Is This Answer Correct ? | 17 Yes | 5 No |
Post New Answer View All Answers
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is the benefit of partitioning a session?
What is an expression transformation in informatica?
What is the sql query overwrite in source qualifier in informatica
Explain lookup transformation in informatica
what is song in infrmatica...?
What does role playing dimension mean?
What is a surrogate key?
Is it possible to define a single node as a Gateway node as well as worker node?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Which transformation is needed while using the Cobol sources as source definitions?
What is meant by active and passive transformation?
What is an aggregator transformation?
What is an unconnected transformation?
How to implement security measures using repository manager?
