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
- 16852 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 is the difference between router and filter?
Target increases every day even though no new record was inserted
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Reusable transformation and shortcut differences
differences between service based and product based?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
can we override a native sql query within informatica? Where do we do it? How do we do it?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
what are the deliverables?in your project?
What is the Process to creating lookup transformation in informatica
Explain about Informatica server process that how it works relates to mapping variables?
What is difference between a gateway node and worker node?
Write the unconnected lookup syntax and how to return more than one column.
What is the need of an ETL tool?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
