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
- 10691 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sivakumar
SQ-->EXP-->ROUTER-->TRg
EMPID
IN_EMPID
in exp t/r
create variable port v_flag in that write the following condition
IIF(EMPID = IN_EMPID ,'1','0')
in router develop 2 conditions for v_flag
the values in the true will b directed to one output which we get the duplicated values
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to load data in informatica ?
Where is metadata stored?
How union transformation is used?
what is the size of u r source(like file or table)?
Briefly define a session task?
Explain the etl program with few examples.
What is the meaning of up gradation of repository?
What is session task and command task?
Explain the informatica workflow?
What is a grid in Informatica?
What are the different transaction levels available in transaction control transformation?
What is a node in Informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is a mapplet/worklet in informatica?
What is dimensional table?
