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
- 8782 Views
- I also Faced
- E-Mail Answers
Answer Posted / sakthi
1.sq1 (query override gender='m') -> exp1 ,seq1 gen nextval to exp1
2.sq2 (query override gender='f') -> exp2 ,seq2 gen nextval to exp2
3. connnect o/p exp1 to exp2 to joiner
* condition nextvalue =nextvalue
* condition type full outer join
4. connect name from exp1 & name from exp2 to target
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is meant by lookup transformation? Explain the types of lookup transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
What is depict expression change?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
what is SDLC way of code development?
What are the transformations that are not supported in mapplet?
Explain incremental aggregation in informatica
How do you change a non-reusable transformation to reusable transformation?
How might you approve all mappings in the archive all the while?
What is meant by query override?
What is a transaction control transformation?
How to create or import flat file definition in to the warehouse designer?
What is domain and gateway node?
What is the scenario which compels informatica server to reject files?
