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
- 15837 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
Can we create a node as a gateway node and the same node can be assigned to a grid?
explain abt ur project architecture?
Explain the scenario which compels informatica server to reject files?
Why is sorter an active transformation?
What is native users?
What is a rank transform?
What are the types of data warehouses?
What is data caches/ index caches?
What all are steps in up gradation of Informatica server?
Explain the difference between a data warehouse and a data mart?
Briefly define a session task?
What do think which one is the better joiner or look up?
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 the use of an aggregator cache file?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
