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
- 16261 Views
- I also Faced
- E-Mail Answers
Answer Posted / shashank
source->SQ->exp[dummyRow=1]->sorter[sort by dummyRow]->
(input to 2 transformation,pipeline branching)
1. joiner[normal join on dummyRow]
2. aggregator[no group by,add port TotalNoOfRows with
expression COUNT(dummyRow)]
Sequence generator->joiner{say port name be RowNo}
{so, joiner will get input from 3 trn, sorter, seq gen &
agg}
Joiner->exp[add port halfNo with exp iff
(RowNo<=TotalNoOfRows/2,1,2)]-> router[halfNo=1,halfNo=2]
->Target1(if halfNo=1)
->Target2(if halfNo=2)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Differentiate between a repository server and a powerhouse?
How to update or delete the rows in a target, which do not have key fields?
Explain the tuning lookup transformation - informatica
What are the differences between joiner transformation and source qualifier transformation?
Why do you use Mapping Parameter and mapping variable?
How do you migrate data from one environment to another?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is Index Caches size?
How you can differentiate between connected lookup and unconnected lookup?
how tokens will generate?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Which files are created during the session rums by informatics server?
How does a sorter cache works?
Write the program through which the records can be updated?
In informatica workflow manager, how many repositories can be created?
