1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / ramesh

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


Please Help Members By Posting Answers For Below Questions

What are the prerequisite tasks to achieve the session partition?

707

can we override a native sql query within informatica? How do we do it?

642

Does an informatica transformation support only aggregate expressions?

604

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1462

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1599




Explain sessions and how many types of sessions are there?

576

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

1680

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

630

What is a router transformation?

621

Target increases every day even though no new record was inserted

1103

what is the hint? how to use it to reduce the query processing in program?

6280

Differentiate between Load Manager and DTM?

1659

What is a rank transform?

670

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1656

What are different types of transformations available in informatica?

580