Interested to Buy Any Domain ? << Click Here >> for more details...
In my sourse i have like
ename,gender
vasu,male
geetha,female
ram,male
suma.female
kesav,male
in my output i need
male,female
vasu,geetha
ram,suma
kesav
- 5 Answers
- 8697 Views
- I also Faced
- E-Mail Answers
Answer Posted / shiva bansal
use router and expr1 for male and expr2 for female
combine them in expression transformation and connect the
expression to target
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Enlist the tasks for which source qualifier transformation is used.
What are the different transaction levels available in transaction control transformation?
Differentiate between joiner and lookup transformation?
How can repository reports be accessed without sql or other transformations?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is pmcmd command?
What are the advantages of informatica?
without table how to come first record only in oracle?
What do you mean by filter transformation?
Where do we use mapping variables in informatica?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Define mapping and session?
Describe the impact of several join conditions and join order in a joiner transformation?
What all join we can perform in LOOKUP transformation?
Differentiate between reusable transformation and mapplet.
