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
- 16424 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
Does an informatica transformation support only aggregate expressions?
What is a repository? And how to add it in an informatica client?
What is status code in informatica?
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 workflow manager?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What do think which one is the better joiner or look up?
permutations of mapplet
Explain the use of aggregator cache file?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Where is metadata stored?
What is a surrogate key?
What all join we can perform in LOOKUP transformation?
How do you load alternate records into different tables through mapping flow?
which one is better performance wise joiner or look up
