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
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What are the types of schemas we have in data warehouse and what are the difference between them?
What are the types of presistent cache in look up tr.
How many ways are there to do 'remove duplicate records in informatica'?
What are the issues you have faced in your project? How did you overcome those issues?
EXL informatica Questions
What is the need of etl tools?
explan ur project architecture?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is fact table? Explain the different kinds of facts.
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
what are 3 tech challenges/ common issues you face?
How many number of sessions can one group in batches?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.