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
- 13249 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
Explain the informatica workflow?
What do you understand by term role-playing dimension?
In informatica workflow manager, how many repositories can be created?
What is a connected transformation?
What are the different types of repositories created using informatica?
What is the reusable transformation?
Explain how to import oracle sequence into informatica?
How union transformation is used?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is informatica etl tool?
Please let me know how to make encryption and decryption with example?
How many numbers of sessions can one group in batches?
What are the uses of etl tools?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
