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 / moorthy g
Source-SQ-Exp-Rtr-Tgt(twice)
Exp:
Flag: DECODE(True, gender='MALE', 'Y','N')
RTR:
Make It Two Group
Flag value is Y then Male is one group.
Defaull is Female
Tgt:
Make It Two;
male - Tgt1
female - Tgt2
=================
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Implementation methodology
What is workflow? What are the components of workflow manager?
What is aggregator transformation in informatica?
What is workflow? What are the components of the workflow manager?
What is main use of mapplet?
What is pmcmd command?
Did u used latest transformations of 8.6.0? for what?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Where do we use mapping variables in informatica?
What do you mean by channel change?
What are the types of schemas we have in data warehouse.
Explain how to import oracle sequence into informatica?
What is the function of union transformation?
what are the deliverables?in your project?