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
- 16249 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rashmi garg
From source to expression connect ID, Name and Amt.
Add one sequence generator and connect to expression
now expression TF is like
expression
----------
ID
Name
Amt
Number
pass number port to aggregator TF to get the max value in
number and pass ID,Name, amt and number from exression to
router and max value from aggregator to router
now router is having ports
Id
Name
Amt
Number
Max
now route the rows on the basis of
number < max/2 (output group 1)
number > max/2 (output group 2)
| Is This Answer Correct ? | 17 Yes | 5 No |
Answer / honey
when u apply the procedure given by Mr.Ramesh u will get
alternative records to be stored in the two flatfiles.
Is this what u wanted.
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / srinivasarao dasari
Find the count of the records using `wc -l` Command and
pass this to mapping varaiable.Now you can route the data
by dividing 2.I hope this would be helpful to you.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / psnadh
Hi,
In the source file if the row count is odd number,then how
can we check the condition to divide the ff into two halves?
If it is even,we can divide the ff into two halves as per
the above solutions.
Please give me reply how to implent that
Thanks in Advance
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / 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 |
Answer / bsgsr
send the flat file data into an expression transformation
and create a new pory say xyz and connect nextval mport on
seq_gen to this. then connect expression to router take two
groups. using the nem port created write conditions.
newport<5 in first group ice versa. i believe this would
work
| Is This Answer Correct ? | 1 Yes | 3 No |
Answer / bala ramesh
in this logic , frist take one sequene genrator
transformation ,pass next value to expression
transformation and also pass id,name,and amt.
in this transformation and also create one output port
(temp).it is decimat type and write codition like
(iif(NEXTVAL %2=0,0,1)) , after take one router
transformation ,pass these ports (id,name,amt and
temp) .then create two group ,one is temp=0 and another one
is temp=1.after pass first group to one flat file ,second
group to second flat file.
| Is This Answer Correct ? | 3 Yes | 6 No |
Answer / sajjan
solution1:- use rank transformation, divide into two
quartiles and pass them to different targets
| Is This Answer Correct ? | 0 Yes | 4 No |
What the difference is between a database, a data warehouse and a data mart?
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
How the informatica server sorts the string values in Rank transformation?
How to delete first 3 rows & last 3 rows in target table in informatica
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
A session S_MAP1 is in Repository A. While running the session error message has displayed
If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
can anyone explain me about sales project in informatica?
Teradata 
