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
How can we use mapping variables in informatica? Where do we use them?
Enlist the tasks for which source qualifier transformation is used.
How are indexes created after completing the load process?
In development project what is the process to follow for an etl developer from day1
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
State the differences between sql override and lookup override?
While migrating the data from one environment to another environment how would you manage the connections?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
without table how to come first record only in oracle?
What are multi-group transformations?
Explain target update override in informatica
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is different between the data warehouse and data mart?
How can you validate all mappings in the repository simultaneously?