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
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
explain about unit testing? in real time?
What does update strategy mean, and what are the different option of it?
What is a filter transformation?
what is size of u r database?
When do you use sql override in a lookup transformation?
How can we create index after completion of load process?
What is option by which we can run all the sessions in a batch simultaneously?
Sequence generator, when you move from develoment to production how will you reset
Repository user profiles
can we override a native sql query within informatica? Where do we do it?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How will the document be delivered to me?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
How to update or delete the rows in a target, which do not have key fields?
What are the designer tools for creating transformations?