Interested to Buy Any Domain ? << Click Here >> for more details...
hi all hi have flat file like below my requirement is
empid,ename,sal,loc
101,vamshi,5000,hyd
101,vamshi,5020,hyd
201,raju,5000,hyd
202,ram,4000,hyd
203,kumar,3500,pune
203,kumar,3500,pune
203,kumar,5000,hyd
203,kumar,6000,hyd
i want the o/p like this
in one target
201,raju,5000,hyd
202,ram,4000,hyd
and in second target
101,vamshi,5000,hyd
101,vamshi,5020,hyd
203,kumar,3500,pune
203,kumar,3500,pune
203,kumar,5000,hyd
203,kumar,6000,hyd
- 9 Answers
- 10678 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / redflower
src->sq->exp->router->trg1
->trg2
create one variable port and write the substr() function
ename like k% is goes to one trg and remaining records goes
to another trg by using router t/r
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
Differentiate between a repository server and a powerhouse?
What is the use of source qualifier?
What is target load order?
What is the Rank index port in Rank transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Describe expression transformation?
How can you define user defied event?
Separate from a database, an information bazaar, and an information stockroom?
Briefly explain the aggregator transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How you can differentiate between connected lookup and unconnected lookup?
Write the program through which the records can be updated?
Is it possible to define a single node as a Gateway node as well as worker node?
What are the performance considerations when working with aggregator transformation?
how tokens will generate?
