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.
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 the main features of Oracle 8i with context to datawarehouse?
what are 3 tech challenges/ common issues you face?
Define joiner transformation?
What is parallel processing in informatica?
What are the different lookup cache(s)?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is Cognos script editor?
Explain about cumulative Sum or moving sum?
What is enterprise data warehousing?
Why sorter is an active transformation?
Explain lookup transformation source types in informatica
What is a grid in Informatica?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What are the components of workflow manager?
Design a mapping to load a target table with the following values from the above source?