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
On which transformations you created partitions in your project?
What is a router transformation?
How to go to the older version for a mapping?
what is the size of u r source(like file or table)?
What are the different types of olap? Give an example?
How to handle decimal places while importing a flatfile into informatica?
Differentiate between router and filter transformation?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Explain how many types of dimensions are available in informatica?
What are the components of workflow manager?
What if the source is a flat-file?
Enlist the tasks for which source qualifier transformation is used.
What is a pre-defined event and user-defined event?
Explain what are the different types of transformation available in informatica.
Performance tuning( what you did in performance tuning)