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 / 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
r u done any partitions in ur project?
What is exclusive and normal mode for repository services?
How can we use mapping variables in informatica? Where do we use them?
Describe the impact of several join conditions and join order in a joiner transformation?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is olap (on-line analytical processing?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Explain the difference between mapping parameter and mapping variable?
What do you understand by SOA of Informatica?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is rank transform?
Separate from an archive server and a powerhouse?
how tokens will generate?
what is the hint? how to use it to reduce the query processing in program?
What is intricate mapping?