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
- 16422 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
What is target designer and target load order?
tell me about your project functionality
how many types of dimensions are available in informatica?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is xml source qualifier transformation in informatica?
my source is junk data how will u remove that junk data by using unix please any one replay me
what is the size of u r source(like file or table)?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How many number of sessions can one group in batches?
What are the differences between a connected lookup and unconnected lookup?
Could you explain what is enterprise data warehouse?
What is enterprise data warehousing?
How big was your fact table
What are the new features of informatica 9.x at the developer level?
What are roles and groups and benefits of using them?
