Interested to Buy Any Domain ? << Click Here >> for more details...
following source
name gender
ramya female
ram male
deesha female
david male
kumar male
i want the target
male female
ram ramya
david deesha
kumar
any body give solution above question?
- 4 Answers
- 8373 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / chiky
map1
map1
1.source
2.sorter
3.filter ( gender = male)
4.connect to male_name column in target
map2
1.source
2.sorter
3.filter( gender = female)
4.connect to female_namw column in same target)
target load plan 1,2
start the load.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Define mapplet?
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
What is event and what are the tasks related to it?
What is a standalone command task?
permutations of mapplet
How you know when to use a static cache and dynamic cache in lookup transformation?
What is substr in informatica?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How do you set a varible in incremental aggregation
How can you generate reports in informatica?
What is a repository? And how to add it in an informatica client?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the main issues while working with flat files as source and as targets ?
Explain the scenario which compels informatica server to reject files?
