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
- 16226 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are data-driven sessions?
What is joiner change?
what is the difference between informatica6.1 and infomatica7.1
How do you load alternate records into different tables through mapping flow?
what is mean by complex business rule ?
Difference between Target-based loading and constraint-based loading?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Informatica settings are available in which file?
What is an expression transformation in informatica?
What is data transformation manager process?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is InformaticaPowerCenter?
What is rank transformation in informatica
can you please explain me pre session and post session options?
How many ways a relational source definition can be updated and what are they?
