Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 8 Answers
- 12497 Views
- BRAD, TCS, I also Faced
- E-Mail Answers
Answer Posted / jaspreet banga
after source qualifier, Use an expression transformer , in
that take an variable port name 'FLAG', and in that use the
decode function as 'FLAG = DECODE(GENDER=MALE,'M','F')'.
after that place an router transformer and for each flag
condition use seperate instance of target and hence you
will get what you want.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is size of u r database?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Did u used latest transformations of 8.6.0? for what?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What are batches?
Differentiate between Load Manager and DTM?
Explain what is informatica metadata and where is it stored?
Is it possible to create multiple domains on a single Informatica server?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is event and what are the tasks related to it?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How you can differentiate between connected lookup and unconnected lookup?
Clarify the utilization of aggregator cache record?
What is target load order?
What do you mean by filter transformation?
