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?

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


Please Help Members By Posting Answers For Below Questions

What are the new features of informatica 9.x at the developer level?

600


What is primary and backup node?

692


Enlist the differences between database and data warehouse.

545


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1493


Name at least 5 different types of transformations used in mapping design and state the use of each.?

668






How to improve the performance of a session using sorter transformation?

686


How can you generate reports in informatica?

575


How to do the error handling of if ur source is flatfiles?

1508


What are multi-group transformations?

562


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

1836


Separate from a database, an information bazaar, and an information stockroom?

605


What is meant by lookup transformation? Explain the types of lookup transformation?

565


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1533


what is SDLC way of code development?

1555


What is an expression transformation?

586