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
- 11043 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ramesh
target1
SQ->Router->
target2
1.In router create one group and specity
the condition empid=201 or empid=202.
2.It is connected to target1.
3.Default group is connected to target2.
Thanks & Regards
Ramesh
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What is the advantage of informatica?
Why is sorter an active transformation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is a joiner transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How to create or import flat file definition in to the warehouse designer?
Explain the use of aggregator cache file?
How to elaborate tracing level?
What is intricate mapping?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Define enterprise data warehousing?
What is difference between a gateway node and worker node?
