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
write a query to retrieve the latest records from the table sorted by version(scd)
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Difference between Target-based loading and constraint-based loading?
r u done any partitions in ur project?
explain about unit testing? in real time?
How do you take back up of repository?
What is pmcmd command?
Enterprise data warehouse your projects phase by phase explain?
What does command task mean?
What is session task and command task?
What is confirmed fact in dataware housing?
Do you find any difficulty while working with flat files as source and target?
can we override a native sql query within informatica? Where do we do it?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What are the different components of powercenter?